IBM Support

PI29843: WITH GERMAN FORMATTING, NUMBERS USING A COMMA ARE CORRUPTED WHEN EXPORTING TO EXCEL

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • If your machine is setup to format numbers using German
    standards, when exporting a number which includes a comma to
    excel, that comma is replaced by a full stop.
    
    This changes the meaning of the number. E.g. 4,567 (four point
    five size seven) is converted to 4.567 (four thousand five
    hundred and sixty seven).
    
    This is actually a problem with Excel and can also be seen when
    running VB from (e.g.) Word to assign the same value to cell.
    
    To recreate:
    
     - in Control Panel;Regional and Language set the Format to
    "German (Germany)"
     - enter a value such a 4,567 into a DOORS module
     - export the module, including that value, to Excel.
     - observe that the command has been replaced with a full stop.
    
    Workaround:
    
    In "DOORSHOME\lib\dxl\standard\export\office\excel.dxl" find the
    following lines and comment out the condition so that every
    value is preceded by an apostrophe and forced to be a string:
    
    "
        if( s[0:0] == (NLS_("=")) || s[0:0] == (NLS_("+")) || s[0:0]
    == (NLS_("-")) || s[0:0] == (NLS_("@")) || dateCheck s )
        {
            s = (NLS_("'")) s
        }
    "
    
    It may be better to enhance the condition to check for the
    German locale setting and the problematic number format, so that
    other values are not also affected.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Users exporting data to Excel                                *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * If your machine is setup to format numbers using German      *
    * standards, when exporting a number which includes a comma to *
    * Excel, that comma is replaced by a full stop.                *
    *                                                              *
    * This changes the meaning of the number. E.g. 4,567 (four     *
    * point five size seven) is converted to 4.567 (four thousand  *
    * five hundred and sixty seven).                               *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    This is actually a problem with Excel and can also be seen when
    running VB from Word to assign the same value to cell.
    

Problem conclusion

  • This has been resolved in the 9614 release.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PI29843

  • Reported component name

    TLOGIC DOORS WE

  • Reported component ID

    5724V97WA

  • Reported release

    951

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2014-11-18

  • Closed date

    2015-10-23

  • Last modified date

    2015-10-23

  • 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

    TLOGIC DOORS WE

  • Fixed component ID

    5724V97WA

Applicable component levels

  • R961 PSY

       UP



Document information

More support for: Rational DOORS

Software version: 9.5.1

Reference #: PI29843

Modified date: 23 October 2015