How to avoid truncating issue while data downloading to excel sheet

[former_member244346]

Hello Experts,

I have requirement in alv report, in report output when i am downloading to excel sheet few fields value getting truncate like vendor field value showing in sap output - 0123450 but after download to excel the value downloading to excel 12345 it should download 123450.

Anyone can help me on this.

Thanks.

[mangesh_parihar]

Hi,

Before downloading, move those field to the another table table2 which well have same number of fields but of type string.

And download the table2. That should work.

Regards,

Mangesh Parihar

[JL23]

Which ALV report? Standard or own developed?

Never saw that trailing zeros have been missed in a download

[former_member244346]

Own developed report.

[JL23]

Then it might be of some help to show the coding that is used around the download

[DanielP]

Hej Ramesh,

Have you tried with ALV format 10-Excel (in Office 2007 XLSX Format).

These settings can be overwritten in SE38 with program SALV_BS_ADMIN_MAINTAIN.

Table SALV_CSQ_PARAMS display settings per User.

Hope it helps 🙂