04-06-2009 12:18 PM
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
04-06-2009 12:21 PM
check the foll. and correct it accordingly
1. optimize the column widths
2. check its output lengths
3. check its format type
04-06-2009 12:21 PM
check the foll. and correct it accordingly
1. optimize the column widths
2. check its output lengths
3. check its format type
04-06-2009 12:35 PM
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
04-06-2009 12:44 PM
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
04-06-2009 1:24 PM
Set:
W_fieldcat-datatype = ' '.
OR.
W_fieldcat-Outputen = ' '.
Hope this resolves your issue.
Regards,
Gurpreet
04-06-2009 5:02 PM
Check the OSS note also as its a know problem data truncated/missing in while transporting to Excel.
Regards,
Atul
05-30-2009 7:20 AM
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