IBM Support

PH04402: DOORS 9.6.1.9 EXCEL EXPORT OF BOOLEAN ATTRIBUTES CREATES TEXT VALUES IN MS EXCEL.

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

  • DOORS 9.6.1.9 Excel Export of Boolean attributes creates text
    values in Excel. Whereas in DOORS (9.5.x)  proper Boolean values
    were exported
    
    DOORS data:
    attribute xy(boolean)
    #1 True
    #2 False
    
    XLSX (2016) from 9.5.0.7:
    A1 TRUE   =TRUE()
    A2 FALSE  =FALSE()
    
    XLSX (2016) 9.6.1.9, 9.6.1.10 and 9.6.1.11:
    A1 "True
    A2 "False
    
    CSV Export is identical between 9.5.0.8 and 9.6.1.11 and
    produces proper BOOLean values in Excel 2016.
    
    9508
    "ID",,"xy"
    1,"1 test1","True"
    2,"2 test2","False"
    
    9611
    "ID",,"xy"
    1,"1 test1","True"
    2,"2 test2","False"
    
    
    Workaround:
    Use export to csv.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All DOORS users.                                             *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * Export to Excel of boolean attributes creates test values in *
    * Excel.                                                       *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    Client side fix.
    

Problem conclusion

  • This has been resolved in the DOORS 9.7 release.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PH04402

  • Reported component name

    TLOGIC DOORS

  • Reported component ID

    5724V61DR

  • Reported release

    961

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2018-10-23

  • Closed date

    2019-07-09

  • Last modified date

    2019-07-09

  • 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



Document information

More support for: Rational DOORS

Software version: 961

Reference #: PH04402

Modified date: 09 July 2019