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 for Me (Login required).

Search for additional results

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