ALV Downloaded to XLSX, the numeric fields are saved as text

[former_member206394]

Dear Experts,

Greetings!

I have an ALV in my SAP ABAP report. When the ALV output is downloaded to XLS format excel sheet; all the fields are proper. meaning the numeric fields are saved as numeric fields only which is as expected. The same ALV output, when downloaded to XLSX format, the numeric fields are saved as text. User need to convert all columns from text to number to be able to calculate sum in excel. We need the fields to be saved as numeric values

Please help with this. Both XLS & XLSX formats should give the numeric fields as numeric fields.

Regards

Shankar

[FredericGirod]

try ABAP2XLSX

[former_member206394]

Dear Frederic,

We are using CL_GUI_ALV_GRID=>SET_TABLE_FOR_FIRST_DISPLAY to display the ALV. It already has the Download option. From there, we are downloading the output into XLS, XLSX format excel files.

XLS file is all as expected.

XLSX file - the numeric fields are saved as text. User need to convert all columns from text to number to be able to calculate sum in excel. We need the fields to be saved as numeric values

Regards,

Shankar

[Sandra_Rossi]

I'm surprised that the numbers are not exported as numbers. There are many options to export to XLSX, maybe you didn't choose the right one.

[FredericGirod]

hide the button, create a new one. With a beautiful class managing dynamicaly the fieldcatalog. After this you could call it in all your ALV grid

[former_member206394]

This is how we downloaded the xlsx file

[former_member773384]

Hi

Can you share the code for download the alv into XLSX file format.