PM48764: LONG, FAST RENDERED TABLES WITH TITLE EXPORTED TO WORD: TITLE AND COLUMN HEADER IS REPEATED ON EVERY PAGE

APAR status

• Closed as program error.

Error description

• You work with IBM SPSS Statistics 19.0.0.1 or 20 release and you
  create long pivot tables with a title, e.g. a custom table or a
  case summaries table. In both releases you use FAST rendered
  tables (SET TABLERENDER = FAST).
  After table creation you export your output file as MS Word
  document *.doc
  
  However, when you open the exported doc in Word you notice that
  the long table is interrupted on every page since the table
  title and the column label headers are repeated on each exported
  page.
  
  This was reported to IBM SPSS Development. It is expected to be
  addressed with IBM SPSS Statistics 20 FixPack 1.
  As a work around go to Edit - Options - Pivot tables tab and
  select "Render as
  legacy tables" in release 20 and in release 19 select "Render
  tables with all features" on that tab.
  The syntax for this would be SET TABLERENDER = FULL.
  After that create your lond tables again and export them as Word
  DOC. The exported tables will have no unexpected table breaks,
  titles and column headers are not repeated.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users working with fast tables with titles exporting to Word *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * You work with IBM SPSS Statistics 19.0.0.1 or 20 release and *
  * you                                                          *
  * create long pivot tables with a title, e.g. a custom table   *
  * or a                                                         *
  * case summaries table. In both releases you use FAST rendered *
  * tables (SET TABLERENDER = FAST).                             *
  * After table creation you export your output file as MS Word  *
  * document *.doc                                               *
  *                                                              *
  * However, when you open the exported doc in Word you notice   *
  * that                                                         *
  * the long table is interrupted on every page since the table  *
  * title and the column label headers are repeated on each      *
  * exported                                                     *
  * page.                                                        *
  *                                                              *
  * This was reported to IBM SPSS Development. It is expected to *
  * be                                                           *
  * addressed with IBM SPSS Statistics 20 FixPack 1.             *
  * As a work around go to Edit - Options - Pivot tables tab and *
  * select "Render as                                            *
  * legacy tables" in release 20 and in release 19 select        *
  * "Render                                                      *
  * tables with all features" on that tab.                       *
  * The syntax for this would be SET TABLERENDER = FULL.         *
  * After that create your lond tables again and export them as  *
  * Word                                                         *
  * DOC. The exported tables will have no unexpected table       *
  * breaks,                                                      *
  * titles and column headers are not repeated.                  *
  ****************************************************************
  * 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