Export to Excel problem

[NunoSilva]

Hello,

I am having a very strange problem.

I have an ALV with diferent fields. When i do "Export to File --> Spreadsheet" the first firld is missing the last digit.

Any ideas on why this happens?

Thank you

Nuno Silva

[NunoSilva]

Hi Nuno,

you should change the 'Width of Output List', this can be done in SE11 on the selection screen for the table you are working woth.

Regards,

Simon

[Former Member]

check the foll. and correct it accordingly

1. optimize the column widths

2. check its output lengths

3. check its format type

[Former Member]

Hi Nuno,

you should change the 'Width of Output List', this can be done in SE11 on the selection screen for the table you are working woth.

Regards,

Simon

[Former Member]

Hi Nuno,

This problem is there for all in currency and date fields.

so down load the file with CSV format and open and try to save as Excel format.

or after down loading the excel format select the column and change the options to Currency.

Regards,

Prabhduas

[Former Member]

Set:

W_fieldcat-datatype = ' '.
OR.
W_fieldcat-Outputen = ' '.

Hope this resolves your issue.

Regards,

Gurpreet

[Former Member]

Check the OSS note also as its a know problem data truncated/missing in while transporting to Excel.

Regards,

Atul

[Former Member]

Hi,

I have the same problem. when i export ALV to spreadsheet, first coloum doesn't have last digit.

Did u solve ur problem?

if u solve plz tell me

Regards,

Anuradha