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

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