IBM Support

PI17738: VALUES CONSISTING ONLY OF POSITIVE NUMBERS IN BRACKETS ARE NOT EXPORTED TO EXCEL CORRECTLY

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • When exporting a positive number in brackets to Excel, the
    brakcets are remove and a minus sign is added.
    
    E.g. add a string column to a module containing values such as
    '(3)' and '(5)' then export it to Excel using
    File;Export;Microsoft Office;Excel.
    
    In Excel the value shown will be '-3' and '-5'.
    

Local fix

  • Add a routine to check for these types of values and prefix with
    an apostrophe where appropriate.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All users/environments affected                              *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * When exporting a positive number in brackets to Excel, the   *
    * brackets are remove and a minus sign is added.               *
    *                                                              *
    * E.g. add a string column to a module containing values such  *
    * as "(3)" and "(5)" then export it to Excel using             *
    * File;Export;Microsoft Office;Excel.                          *
    *                                                              *
    * In Excel the value shown will be "-3" and "-5".              *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to 9.6.0.1                                           *
    ****************************************************************
    DOORS Client fix
    

Problem conclusion

  • This is a standard financial notation where negative balances
    etc are represented in brackets.
    DOORS has been changed to treat bracketed figures as text
    strings,  which will prevent the special treatment.  This is the
    same as existing treatment of strings staring with "+", "-" and
    "="
    

Temporary fix

Comments

APAR Information

  • APAR number

    PI17738

  • Reported component name

    TLOGIC DOORS

  • Reported component ID

    5724V61DR

  • Reported release

    940

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2014-05-12

  • Closed date

    2014-09-11

  • Last modified date

    2014-09-26

  • 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

  • Fixed component ID

    5724V61DR

Applicable component levels

  • R960 PSY

       UP



Document information

More support for: Rational DOORS

Software version: 9.4

Reference #: PI17738

Modified date: 26 September 2014