IBM Support

PM51094: UNABLE TO IMPORT TIME FORMAT VARIABLES OF EXCEL XLS FILE PROPERLY ON MACINTOSH

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • You work with IBM SPSS Statistics releases 19.0.0.1 or 20.0.0
    installed on Macintosh OSX. You created an Excel XLS file on
    Excel for Macintosh application. Your excel file includes a time
    variable of format hh:mm or hh:mm:ss.
    When you import this XLS file into Statistics you notice that
    you lost the time formats. Instead of time values you get
    decimal values for example .04166666666667 instead of 1:00:00
    PM.
    This was reported to IBM SPSS Development. As a workaround save
    your XLS file in excel for Macintosh as XLSX file (Excel 2007
    and above). Import this XLSX file into Statistics and you will
    get the time values properly.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Users working on Macintosh and Excel files with time         *
    * variables                                                    *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * You work with IBM SPSS Statistics releases 19.0.0.1 or       *
    * 20.0.0                                                       *
    * installed on Macintosh OSX. You created an Excel XLS file on *
    * Excel for Macintosh application. Your excel file includes a  *
    * time                                                         *
    * variable of format hh:mm or hh:mm:ss.                        *
    * When you import this XLS file into Statistics you notice     *
    * that                                                         *
    * you lost the time formats. Instead of time values you get    *
    * decimal values for example .04166666666667 instead of        *
    * 1:00:00                                                      *
    * PM.                                                          *
    ****************************************************************
    * 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

    PM51094

  • Reported component name

    SPSS STATISTICS

  • Reported component ID

    5725A54ST

  • Reported release

    J00

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2011-10-28

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

Document Information

Modified date:
01 March 2012