PM52836: FONT SIZES IN PIVOT TABLES DO NOT EXPORT TO EXCEL CORRECTLY

APAR status

• Closed as program error.

Error description

• You work with IBM SPSS Statistics 20 and created some pivot
  tables where you changed the default font size for data cells or
  table titles to a larger size e.g. to 16 pt.
  After that you export your tables as Excel file and open the
  result in Excel.
  You notice that in the Excel file the exported font size for
  data cells and table title is smaller e.g. 12 pt instead of 16
  pt.
  
  This was reported to IBM SPSS Development.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users working with Pivot tables exporting to Excel           *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * You work with IBM SPSS Statistics 20 and created some pivot  *
  * tables where you changed the default font size for data      *
  * cells or                                                     *
  * table titles to a larger size e.g. to 16 pt.                 *
  * After that you export your tables as Excel file and open the *
  * result in Excel.                                             *
  * You notice that in the Excel file the exported font size for *
  * data cells and table title is smaller e.g. 12 pt instead of  *
  * 16                                                           *
  * pt.                                                          *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Install IBM SPSS Statistics 20 FixPack 1 (20.0.0.1)          *
  ****************************************************************
  

Problem conclusion

• Install IBM SPSS Statistics 20 FixPack 1 (20.0.0.1)
  

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