SAP Knowledge Base Article - Preview

1984504 - Cells are formated as 'Text' by default after export to Excel 2007

Symptom

  • After exporting Web Intelligence reports to Excel 2007 (.xlsx) format, the cells surrounding the table are formatted as "Text".
  • This results in not being able to use any calculation formulas such as =SUM().

Read more...

Environment

  • SAP BusinessObjects Business Intelligence platform 4.0 (BI 4.0)
  • SAP BusinessObjects Business Intelligence platform 4.1 (BI 4.1)

Product

SAP BusinessObjects Business Intelligence platform 4.0 ; SAP BusinessObjects Business Intelligence platform 4.1

Keywords

Webi, blank, Excel 2007, save, export,cell, format, text, XI 3.1, BI4, General, xls, xlsx, 文字列, Excel 2010, Excel2007, null , KBA , BI-RA-WBI , Web Intelligence , Bug Filed

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.