I have an ABAP report with which outputs as an ALV grid with 26 Columns. Using the Standard ALV export options -It exports fine into excel using XXL Format, but when using XLSX format the 8 of of the last 10 Columns are missing their data.
It's not the issue with characters such as # or " causing the data to break mid line. Neither is there too much data - The same can happen even if there is only 10 rows to output.
I've been through SAP KB Article 2193144 - [Must-See] Most frequent problems under BC-ABA-LI area. But nothing matches my symptoms.
I've also seen 855314 - Downloading a list from the ALV to Excel. This mentions issue with downloading a list wider than 1023 characters - but the symptom is a line break after 1023 and my output is only 295 chars in the whole row. I'm just missing data for about 8 fields.
Is the issue some standard SAP issue/limitation or is the issue more likely to lie in my ABAP report? We are on Ecc6 EHP7 and I have used G_GRID->SET_TABLE_FOR_FIRST_DISPLAY to display the ALV grid on screen.