PM80465: STATISTICS MISREADING TIME/DATE DATA FROM EXCEL WHERE CELL CONTAINS A FORMULA

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

  • You have a formula defining the time/date value in your
    worksheet (e.g. "=IF(R2>L2,R2-L2,R2-L2+24)").  when you read
    this excel (XLSX) file into Statistics, some of the values are
    displayed with unrealistic values (e.g. "2:-29:-59 AM" instead
    of "1:30").
    

Local fix

  • This issue will be addressed in the next Fix Pack. Please refer
    to the Fix Pack schedule at
    http://www-01.ibm.com/support/docview.wss?uid=swg21599157 for
    information on upcoming Fix Packs.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Statistics 21.0 reading excel time formatted data where the  *
    * underlying cell is a formula.                                *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * You have a formula defining the time/date value in your      *
    * worksheet (e.g. "=IF(R2>L2,R2-L2,R2-L2+24)").  when you read *
    * this excel (XLSX) file into Statistics, some of the values   *
    * are                                                          *
    * displayed with unrealistic values (e.g. "2:-29:-59 AM"       *
    * instead                                                      *
    * of "1:30").                                                  *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to Statistics 21.0 Fix Pack 1.                       *
    ****************************************************************
    

Problem conclusion

  • This issue has been addressed in Statistics 21.0 Fix Pack 1.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM80465

  • Reported component name

    SPSS STATISTICS

  • Reported component ID

    5725A54ST

  • Reported release

    K00

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-01-11

  • Closed date

    2013-03-15

  • Last modified date

    2013-03-15

  • 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:

20.0

Reference #:

PM80465

Modified date:

2013-03-15

Translate my page

Machine Translation

Content navigation