PM90596: EXPORTING PIVOT TABLES TO OFFICE FORMAT FAILS TO RETAIN LINES WITHIN THE TABLE IN SPSS STATISTICS 21 FP1.

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

APAR status

  • Closed as program error.

Error description

  • An output contains pivot tables showing lines to separate
    variable values. When exporting this output to any MS Office
    format (.xls .xlsx .doc .ppt) the lines disappear making the
    pivot table harder to read.
    
    Exporting the same output to .pdf format retains these lines.
    
    Lines within pivot tables should be retained when exporting to
    MS Office format.
    Pivot Tables were created using the default Fast Table engine.
    When the same tables are created using the Legacy Table engine,
    this problem is not present.
    

Local fix

  • This has been reported to IBM SPSS Statistics development team
    for investigation and will be resolved in the next Fix Pack of
    Statistics 21.
    
    Workaround is to generate the pivot tables using the Legacy
    Table engine and then re-export to the MS Office format. You can
    make this change in: Edit > Options > Pivot Tables dialog window
    of SPSS Statistics.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * see APAR text                                                *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * EXPORTING PIVOT TABLES TO OFFICE FORMAT FAILS TO RETAIN      *
    * LINES                                                        *
    * WITHIN THE TABLE IN SPSS STATISTICS 21 FP1.                  *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * This issue has been addressed in IBM SPSS Statistics 21 Fix  *
    * Pack 2                                                       *
    ****************************************************************
    

Problem conclusion

  • This issue has been addressed in IBM SPSS Statistics 21 Fix Pack
    2
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM90596

  • Reported component name

    SPSS STATISTICS

  • Reported component ID

    5725A54ST

  • Reported release

    L00

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-06-06

  • Closed date

    2013-11-25

  • Last modified date

    2013-11-25

  • 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

  • RL00 PSN

       UP

  • RL00 PSY

       UP



Rate this page:

(0 users)Average rating

Document information


More support for:

SPSS Statistics
Statistics Desktop

Software version:

21.0

Reference #:

PM90596

Modified date:

2013-11-25

Translate my page

Machine Translation

Content navigation