2182319 - Incorrect SUM aggregation values when exporting BO XI 3.1 Web Intelligence reports to Excel 2007 (.xlsx) format | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2182319 - Incorrect SUM aggregation values when exporting BO XI 3.1 Web Intelligence reports to Excel 2007 (.xlsx) format

Symptom

  • When exporting a Web Intelligence report to Excel 2007 (.xlsx) format, the result of the SUM function is incorrect in the Excel document.
  • In the Excel 2007(.xlsx) generated spreadsheet a single cell can be found in two merged rows (32-33).
    (The reason is described in KBA 1230109.)
  • When exporting to .xls format, the value is correct.

symp.png


Read more...

Environment

  • SAP BusinessObjects Enterprise XI 3.1 SP7 FP7.2
  • Web Intelligence
  • Microsoft Office

Product

SAP BusinessObjects Enterprise XI 3.1

Keywords

webi, web intelligence, incorrect SUM, .xlsx, .xls, excel output, extra rows, additional cells, alignment, relative position, width , KBA , BI-RA-WBI-FE , Front End/Client , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.