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

Rational Asset Analyzer 6.1
Rational Asset Analyzer for System z 6.1

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 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