IBM Support

PM77179: EXPORTING TO EXCEL 2010 IN IE9 ONLY GIVES OPTION TO EXPORT FULL PAGE, BUT MULTIPLE TABLE OPTIONS USED TO BE AVAILABLE .

Fixes are available

Rational Asset Analyzer 6.1
Rational Asset Analyzer for System z 6.1
Rational Asset Analyzer Fix Pack 3 (6.1.0.3) for 6.1
Rational Asset Analyzer for System z Fix Pack 3 (6.1.0.3) for 6.1
Rational Asset Analyzer Fix Pack 4 (6.1.0.4) for 6.1
Rational Asset Analyzer for System z Fix Pack 4 (6.1.0.4) for 6.1
Rational Asset Analyzer Fix Pack 5 (6.1.0.5) for 6.1
Rational Asset Analyzer for System z Fix Pack 5 (6.1.0.5) for 6.1
Rational Asset Analyzer for System z Fix Pack 6 (6.1.0.6) for 6.1
Rational Asset Analyzer Fix Pack 6 (6.1.0.6) for 6.1
Rational Asset Analyzer Fix Pack 7 (6.1.0.7) for 6.1
Rational Asset Analyzer for System z Fix Pack 7 (6.1.0.7) for 6.1
Rational Asset Analyzer for System z Fix Pack 8 (6.1.0.8) for 6.1
Rational Asset Analyzer Fix Pack 8 (6.1.0.8) for 6.1
Rational Asset Analyzer for System z Fix Pack 9 (6.1.0.9) for 6.1
Rational Asset Analyzer Fix Pack 9 (6.1.0.9) for 6.1
Rational Asset Analyzer Fix Pack 10 (6.1.0.10) for 6.1
Rational Asset Analyzer for System z Fix Pack 10 (6.1.0.10) for 6.1
Rational Asset Analyzer Fix Pack 11 (6.1.0.11) for 6.1
Rational Asset Analyzer for System z Fix Pack 11 (6.1.0.11) for 6.1
Rational Asset Analyzer Fix Pack 12 (6.1.0.12) for 6.1
Rational Asset Analyzer for System z Fix Pack 12 (6.1.0.12) for 6.1
Rational Asset Analyzer Fix Pack 13 (6.1.0.13) for 6.1
Rational Asset Analyzer for System z Fix Pack 13 (6.1.0.13) for 6.1
Rational Asset Analyzer Fix Pack 14 (6.1.0.14) for 6.1
Rational Asset Analyzer for System z Fix Pack 14 (6.1.0.14) for 6.1
Rational Asset Analyzer Fix Pack 15 (6.1.0.15) for 6.1
Rational Asset Analyzer for System z Fix Pack 15 (6.1.0.15) for 6.1
Rational Asset Analyzer Fix Pack 16 (6.1.0.16) for 6.1
Rational Asset Analyzer for System z Fix Pack 16 (6.1.0.16) for 6.1
Rational Asset Analyzer for System z Fix Pack 17 (6.1.0.17) for 6.1
Rational Asset Analyzer Fix Pack 17 (6.1.0.17) for 6.1
Rational Asset Analyzer Fix Pack 18 (6.1.0.18) for 6.1
Rational Asset Analyzer for System z Fix Pack 18 (6.1.0.18) for 6.1
Rational Asset Analyzer Fix Pack 19 (6.1.0.19) for 6.1
Rational Asset Analyzer for System z Fix Pack 19 (6.1.0.19) for 6.1
Rational Asset Analyzer Fix Pack 20 (6.1.0.20) for 6.1
Rational Asset Analyzer for System z Fix Pack 20 (6.1.0.20) for 6.1
Rational Asset Analyzer for System z Fix Pack 21 (6.1.0.21) for 6.1
Rational Asset Analyzer Fix Pack 21 (6.1.0.21) for 6.1
Rational Asset Analyzer Fix Pack 22 (6.1.0.22) for 6.1
Rational Asset Analyzer for System z Fix Pack 22 (6.1.0.22) for 6.1
Rational Asset Analyzer for System z Fix Pack 23 (6.1.0.23) for 6.1
Rational Asset Analyzer Fix Pack 23 (6.1.0.23) for 6.1

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • In prior versions of RAA, when using the Export to Microsoft
    Excel option, multiple options, represented by arrows along the
    edge of the content, were available for choices as to what to
    export.  Using RAA 6.0.0.11 and Excel 2010 with Microsoft
    Internet Explorer 9, only the option to export the whole page
    is given.
    

Local fix

  • Delete or comment this line:
    
     <meta http-equiv="X-UA-Compatible" content="IE=Edge"/>
    
    from the RAA dmhHead.jsp file, which would typically be located
    here:
    
    <wasInstallDir>\profiles\<appServerDir>\installedApps\<nodeCellN
    ame>\wsaa.ear\wsaa.war\dmhHead.jsp
    

Problem summary

  • Microsoft Excel doesn't recognize HTML tables in pages
    generated by RAA fixpack levels 6.0.0.6-v6.0.0.11.
    

Problem conclusion

  • Removed the X-UA-Compatible meta tag so that Microsoft Excel
    can find tables in the HTML.
    

Temporary fix

  • remove the <meta http-equiv="X-UA-Compatible"
    content="IE=Edge"/>    tag in
    <wasInstallDir>\profiles\<appServerDir>\installedApps\<nodeCellN
    ame>\wsaa.ear\wsaa.war\dmhHead.jsp
    

Comments

APAR Information

  • APAR number

    PM77179

  • Reported component name

    RATL ASSET ANAL

  • Reported component ID

    5724V2700

  • Reported release

    600

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-11-15

  • Closed date

    2012-11-20

  • Last modified date

    2012-11-20

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

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

Modules/Macros

  • DMH0731
    dmhhead
    

Fix information

  • Fixed component name

    RATL ASSET ANAL

  • Fixed component ID

    5724V2700

Applicable component levels

  • R600 PSY

       UP

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SS3JHP","label":"Rational Asset Analyzer"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"6.0","Line of Business":{"code":"LOB35","label":"Mainframe SW"}}]

Document Information

Modified date:
29 October 2021