SAP Knowledge Base Article - Preview

2190217 - In Business Intelligence 4.x, when exporting a Web Intelligence report to csv and opening in Excel, it reads text as scientific notation

Symptom

In BI 4.x, if your webi document has a string value that can be interpreted as scientific notation (such as 62E03) and you export to csv then open in Excel, Excel renders it as scientific notation (6.20E+04) instead of 62E03 as expected.


Read more...

Environment

  • BusinessObjects Business Intelligence 4.0
  • BusinessObjects Business Intelligence 4.1
  • Web Intelligence

Product

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

Keywords

comma seperated value 4.0 4.1 2007 xls xlsx archive , KBA , BI-RA-WBI , Web Intelligence , 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.