JR51807: UNSTRUCTURED DATA STAGE DOESN'T SHOW CORRECT COLUMNS WITH XLS FILE WITH CHARTS.

APAR status

• Closed as program error.

Error description

• When the Unstructured Data stage loading an Excel file, which
  has a work sheet with an embedded chart, it wrongly regards the
  embedded chart as a standalone work sheet, and it returns
  incorrect cell values.
  

Local fix

• Save the xls file to xlsx, or move the sheet to load before the
  sheet with chart.
  

Problem summary

• Unstructured Data stage returns incorrect cell values when
  reading a Microsoft Excel file (.xls) containing an embedded
  chart.
  

Problem conclusion

• An original code wrongly regards the embedded chart as a
  stand-alone work sheet. As a result, the state mismatch
  sometimes occurred when reading an Excel file, which contained
  embedded chart(s). By applying this patch, the problem is fixed
  and read an Excel file even if it contains embedded chart(s).
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  WIS DATASTAGE

• Fixed component ID

  5724Q36DS

Applicable component levels

• R910 PSY

     UP

• R912 PSY

     UP