IBM Support

PM68310: EXCEL ERROR WHEN OPENING XLSX FILE IN EXCEL 2010 WHEN NEGATIVE SYMBOL SET TO <

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as fixed if next.

Error description

  • When saving a report in Excel 2007 format (xlsx) containing
    negative values with the negative symbol set to < receive an
    error when opening in Excel 2010 and negative symbol is set back
    to -.??Error:?Excel found unreadable content in 'filename.xlsx'.
    Do you want to recover the contents of this workbook. If you
    trust the source of this work book, click Yes.??Excel was able
    to open the file by repairing or removing the unreadable
    content.?Removed Part: /xl/styles.xml part with xml error.
    (Styles) An attribute value must not contain '<' Line 1, column
    195.?Repaired Records: Cell information from
    /xl/worksheets/sheet1.xml part.??
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All Users                                                    *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See error description.                                       *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to IBM Cognos Business Intelligence 10.2 Refresh     *
    * Pack 1                                                       *
    ****************************************************************
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    PM68310

  • Reported component name

    COG8 BI REPORT

  • Reported component ID

    5724W12RS

  • Reported release

    A11

  • Status

    CLOSED FIN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-07-06

  • Closed date

    2013-06-11

  • Last modified date

    2013-06-11

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Fix information

Applicable component levels

  • RA21 PSN

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSCHNWW","label":"Report Authoring v11x"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"A11","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
11 June 2013