IBM Support

PM57544: COPYING A PIVOT TABLE USING EMF FORMAT WILL LOSE SOME FORMATTING IF FAST TABLE IS USED AND PASTING INTO MS OFFICE APPLICATIONS.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as fixed if next.

Error description

  • In IBM SPSS Statistics 20, after you create a pivot table using
    the new FAST table engine, copying the table as an EMF image
    will lose some formatting when pasting into MS Word.
    
    Formatting lost is a simple horizontal line across the row
    values.
    
    Behaviour is present if the following conditions are used:
    * Tablelook is the default (TLOOK=NONE)
    * Table is created using the Fast table engine
    (TABLERENDER=LIGHT)
    * Copying table using Copy Special > EMF format only
    
    All formatting should be retained when copying using EMF format.
    This is the case if the table is created using the Legacy Pivot
    Table engine (TABLERENDER=FULL) or when copying using an image
    (JPEG).
    

Local fix

  • Current workaround is to generate these tables using the Legacy
    Pivot Table engine. This can be set via Edit > Options > Pivot
    Tables > Table Rendering option or by running the command:
    SET TABLERENDER=FULL .
    
    Other workaround is to copy the pivot table as an Image file
    (JPG, PNG) rather than an Metafile (WMF, EMF).
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Users copying tables as EMF image                            *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * In IBM SPSS Statistics 20, after you create a pivot table    *
    * using the new FAST table engine, copying the table as an EMF *
    * image                                                        *
    * will lose some formatting when pasting into MS Word.         *
    *                                                              *
    * Formatting lost is a simple horizontal line across the row   *
    * values.                                                      *
    * Behaviour is present if the following conditions are used:   *
    * * Tablelook is the default (TLOOK=NONE)                      *
    * * Table is created using the Fast table engine               *
    * (TABLERENDER=LIGHT)                                          *
    * * Copying table using Copy Special > EMF format only         *
    *                                                              *
    * All formatting should be retained when copying using EMF     *
    * format.                                                      *
    * This is the case if the table is created using the Legacy    *
    * Pivot                                                        *
    * Table engine (TABLERENDER=FULL) or when copying using an     *
    * image                                                        *
    * (JPEG).                                                      *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * This issue is resolved with IBM SPSS Statistics 21 release.  *
    ****************************************************************
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    PM57544

  • Reported component name

    SPSS STATISTICS

  • Reported component ID

    5725A54ST

  • Reported release

    K00

  • Status

    CLOSED FIN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-02-07

  • Closed date

    2012-08-30

  • Last modified date

    2012-08-30

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Fix information

Applicable component levels

  • RL00 PSN

       UP

  • RL00 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:
30 August 2012