ALV to EXCEL, data being truncated

[Former Member]

I am trying to download my ALV output into excel spreadsheet, but for one of the field, the column is being truncated. EG the no 123456 is coming as 12345.. please help

Thanks

Nirmal

[former_member181962]

Check the definition (or declaration of the field in the internal table).

If it is correct(6 digits) then check the column width in the excel sheet.

Resize the column in the excel sheet to view it fully.

Regards,

Ravi

[Former Member]

I even compared the declarations, they are same and there is no problem in excelsheet also. Can there be any problem with the Field Catalog.

[former_member188685]

Hi Nirmal,

this is well known problem, try doing this..

while building the fieldcat for that field, give this also

<b>fieldcat-no_zero = 'X'.</b>

this solves your Problem

Regards

vijay

[Former Member]

Hi Nirmal,

Try Giving <b>fieldcat-no_zero = 'X'</b>. Hope this works

Regards,

Santosh