IBM Support

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

Subscribe

You can track all active APARs for this component.

 

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 number

    PM48764

  • Reported component name

    SPSS STATISTICS

  • Reported component ID

    5725A54ST

  • Reported release

    K00

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2011-09-27

  • Closed date

    2012-03-01

  • Last modified date

    2012-03-01

  • 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

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSCQ88K","label":"Statistics Desktop"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"20.0","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
01 March 2012