05-21-2009 5:52 PM
Hi,
I am downloading internal table to excel using cl_gui_frontend_services=>gui_download.
There is a coloumn with 16 digit number in my table and when i download it to excel it is
showing in scientific format. eg: '1234567899999998' shows as '1.23E+15. I want this to be downloaded as is. We can change the cell settings to modify it in excel but our users not ready to change it manually.Is there a way to solve this issue. I tried different options.Please help me out.
Thank You.
Ashok
05-21-2009 7:55 PM
I guess the only option are to either Manually double click and expand the length of the column to show the whole number OR use OLE for the Excel download. In OLE you might not get this issue as you have an option of specifying the column width.
05-21-2009 5:54 PM
05-21-2009 6:00 PM
I tried with 'SAP_CONVERT_TO_XLS_FORMAT'. it is also showing the same scientific form.
Thank You.
05-21-2009 7:45 PM
Try expanding the field's column lenght or changing the field's format in excel to numeric
05-21-2009 7:55 PM
Hi,
experimented it. Tried it earlier but same prob exist.
Thanks
Ashok
05-21-2009 7:55 PM
I guess the only option are to either Manually double click and expand the length of the column to show the whole number OR use OLE for the Excel download. In OLE you might not get this issue as you have an option of specifying the column width.
05-26-2009 7:19 PM