PM49520: NUMERIC EXCEL FIELD FORMATTED AS "GENERAL" LOSES DECIMALS WHEN IMPORTED INTO STATISTICS 20

APAR status

• Closed as program error.

Error description

• You are reading your numeric and string data from Excel (*.xlsx)
  into Statistics 20.  Columns which should have  decimal portions
  are appearing in Statistics 20 with the integer portion only.
  

Local fix

• Check the format of your numeric field.  Numeric fields
  formatted as "General" appear to be coming in this way.  change
  the format to "Number", and the values come in correctly.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users importing decimal values from Excel (*.xlsx) where the *
  * data fields are numeric thought formatted in Excel as        *
  * "General"                                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * You are reading your numeric and string data from Excel      *
  * (*.xlsx)                                                     *
  * into Statistics 20.  Columns which should have  decimal      *
  * portions                                                     *
  * are appearing in Statistics 20 with the integer portion      *
  * only.                                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Update to Statsitics 20 Fixpack 1                            *
  ****************************************************************
  

Problem conclusion

• Update to Statsitics 20 Fixpack 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

• RK00 PSN

     UP

• RK00 PSY

     UP