SAP Knowledge Base Article - Preview

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


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


"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."



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


SAP BusinessObjects Enterprise XI 3.1


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.