Analytics Version 7.8.2 downloading Analytics Reports to MS Excel Format produces garbled characters

Background
In Analytics Version 7.8.2 downloading Analytics Reports to MS Excel Format produces garbled characters in the Excel file if the MS Excel Version at the client machine is MS Excel 2000 or lower. This behavior affected both reports with table views and report with single table views.

Solution
Analytics 7.8.2 requires MS Excel 2002 or newer version to support download to MS Excel. This is to enable the download of Analytics report including charts with same look and feel as displayed in the Analytics Web Client. Versions of MS Excel prior to MS Excel 2002 do not support inline binary data to embed the charts therefore the garbled data displayed when the report is opened with older versions of MS Excel. As workaround users may opt to download the report to CSV format instead by making changes in viewcontrolmessages.xml file.


http://www.siebeldigest.com/