PM65902: CELLS OF FAST RENDERED TABLES BELOW 1% ARE EXPORTED AS % INSTEAD OF 0% TO EXCEL XLS FILE

APAR status

• Closed as program error.

Error description

• You work with IBM SPSS Statistics 20 and create some fast
  rendered pivot tables with percent values displayed with format
  0 decimal values. Some percent values are below 1% and are
  displayed as 0% on the table. The exact value of the cell is
  displayed in the background e.g. as .1234%
  The you export these tables with output export as Excel XLS
  file. However, when you open the exported file you see for the
  cells with the 0% a % percent sign only in the cell but not 0%.
  However, this is only a cosmetic issue because the exact cell
  value is in the background of the exported cell too.
  
  This was reported to IBM SPSS Development. As a workaround
  create the same table agian but as full rendered legacy table
  (set tablerender = full). When you export this full rendered
  table to Excel cells with percentages <1% are displayed as 0%
  instead of %.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users exporting fast tables to MS Excel                      *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * You work with IBM SPSS Statistics 20 and create some fast    *
  * rendered pivot tables with percent values displayed with     *
  * format                                                       *
  * 0 decimal values. Some percent values are below 1% and are   *
  * displayed as 0% on the table. The exact value of the cell is *
  * displayed in the background e.g. as .1234%                   *
  * The you export these tables with output export as Excel XLS  *
  * file. However, when you open the exported file you see for   *
  * the                                                          *
  * cells with the 0% a % percent sign only in the cell but not  *
  * 0%.                                                          *
  * However, this is only a cosmetic issue because the exact     *
  * cell                                                         *
  * value is in the background of the exported cell too.         *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * This issue has been addressed in IBM SPSS Statistics 20      *
  * Fixpack 2 (20.0.0.2)                                         *
  ****************************************************************
  

Problem conclusion

• This issue has been addressed in IBM SPSS Statistics 20 Fixpack
  2 (20.0.0.2)
  

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

  SPSS STATISTICS

• Fixed component ID

  5725A54ST

Applicable component levels

• RK00 PSN

     UP

• RK00 PSY

     UP