IBM Support

PI78788: SAVE TRANSLATE FAILS ON /APPEND /EXCELOPTIONS WHERE /CELLS=LABELS

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • You are selectively exporting records from an active IBM SPSS
    Statistics system file to an Excel file where each unique subset
    is written to a new sheet in a common workbook.
    
    You have elected to export the VALUE LABELS rather than the
    actual values when labels are defined e.g. "/CELLS=labels"
    subcommand to the SAVE TRANSLATE /TYPE=XLS command.  Excel
    complains of unreadable information in your exported files.
    
    You find that if you instead export values (e.g. "CELLS=values")
    the files are created/updated without error and excel reads them
    without error.
    

Local fix

  • This issue will be addressed in the next Fixpack.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Users of IBM SPSS Statistics 24.0 trying to append to an     *
    * existing Excel workbook and save value labels rather than    *
    * values                                                       *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * You are selectively exporting records from an active IBM     *
    * SPSS                                                         *
    * Statistics system file to an Excel file where each unique    *
    * subset                                                       *
    * is written to a new sheet in a common workbook.              *
    *                                                              *
    * You have elected to export the VALUE LABELS rather than the  *
    * actual values when labels are defined e.g. "/CELLS=labels"   *
    * subcommand to the SAVE TRANSLATE /TYPE=XLS command.  Excel   *
    * complains of unreadable information in your exported files.  *
    *                                                              *
    * You find that if you instead export values (e.g.             *
    * "CELLS=values")                                              *
    * the files are created/updated without error and excel reads  *
    * them                                                         *
    * without error.                                               *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Please upgrade to IBM SPSS Statistics 24.0 FP2               *
    ****************************************************************
    

Problem conclusion

  • This issue has been resolved for IBM SPSS Statistics 24.0 FP2
    

Temporary fix

Comments

APAR Information

  • APAR number

    PI78788

  • Reported component name

    SPSS STATISTICS

  • Reported component ID

    5725A54ST

  • Reported release

    O00

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2017-03-24

  • Closed date

    2017-05-17

  • Last modified date

    2017-05-17

  • 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

  • RO00 PSN

       UP

  • RO00 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":"O00","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
17 May 2017