SAP Knowledge Base Article - Preview

1854956 - Common issue with Export to excel

Symptom

Case 1. List object is too large to be exported
Case 2. key figures value with "ZERO" are formatted as TEXT calculation not possible
Case 3. Wrong exception color when exported
Case 4. JavaScript during drag & drop after export to Excel
Case 5. Export to Excel results in blank windows opening up
Case 6. portal crash/memory/timeout issue during EXPORT to Excel
Case 7. the exported file name is the name of the template, want to change the name
Case 8. Percent (%) not exported when using cumulative Calculation
Case 9. Get the warning message "The file you are trying to open is in a different format...".
Case 10. Repeats suppressed values when doing export to excel
Case 11. Export to Excel generate a very big file
Case 12. java.lang.NoClassDefFoundError: sun.awt.motif.MToolkit (initialization failure)
Case 13. Missing Notification on Downloads of documents
Case 14. disappearing chart image after exporting the content to Excel
Case 15. prompted logon screen when doing export to excel
Case 16. Decimal places ignored when there are values of 0,0 after export to excel
Case 17. Hidden columns are visible when exported
Case 18. Unable to save a file in XLSX format
Case 19. The headers of the columns are merged
Case 20. Standard images like sorting icon, document icon, hierarchy icon, etc. While exporting to excel, these images are also exported together which in turn causes performance issue while opening the excel file.


Read more...

Environment

SAP BW Netviewer 700/701/730/740

Product

SAP NetWeaver 7.0 ; SAP NetWeaver 7.3 ; SAP NetWeaver 7.4 ; SAP enhancement package 1 for SAP NetWeaver 7.0 ; SAP enhancement package 1 for SAP NetWeaver 7.3 ; SAP enhancement package 2 for SAP NetWeaver 7.0 ; SAP enhancement package 3 for SAP NetWeaver 7.0

Keywords

Export, Excel, Date, Text, Dot, Thousand, 2010, Missing, format, Decimal, Custom, Hidden , column, navigation, colour, drag and drop, Blank window, logon, Template, Different format, sun.awt.motif.MToolkit , Drilling sun, loading animation, Chart, Standard image, performance , KBA , BW-BEX-ET-WJR-EXP , Export Services and Printing , 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.