topic Re: Problem with export to excel in Application Development and Automation Discussions

Problem with export to excel

Former Member — Tue, 28 Nov 2006 03:30:16 GMT

Hi..

When i download a report into an excel sheet using Export --> Local File --> Spreadsheet, and open it, the last digit of the sales order number does not get displayed..

What could be the reason for this? The report displays the correct sales order no.

Any ideas? Thanks in advance.

Keshi

Re: Problem with export to excel

Former Member — Tue, 28 Nov 2006 03:35:25 GMT

Hi Keshi

Please clarify on the below:

1. Is the sales order number the first column or last column or in middle.

2. Eg: Sales Order number is : 0123456789

It is downloaded as : 123456789 or 012345678???

Kind Regards

Eswar

Re: Problem with export to excel

Former Member — Tue, 28 Nov 2006 03:37:54 GMT

The sales order number is in the middle.

If the sales order no is 0003000195 it is downloaded as 300019.

Re: Problem with export to excel

anversha_s — Tue, 28 Nov 2006 03:49:23 GMT

hi,

try to increase the width of sales num column in the field catlog.

rgds

Anver

Re: Problem with export to excel

Former Member — Tue, 28 Nov 2006 03:50:38 GMT

Hi Keshi

Thatz the default setting of Excel that property of cells will be general, hence the leading zeroes for the cell value gets truncated. This is only while displaying in the file.

You can check the same to make sure that the leading zeroes exist if you open the same file with a notepad without saving the earlier one.

Kind Regards

Eswar

Re: Problem with export to excel

Former Member — Tue, 28 Nov 2006 03:54:24 GMT

Hi Eswar..

The 0's are not the probelm. The sales order 0003000195 when downloaded displays as 300019.. Without the digit 5 at the end.

I want it to be displayed as 3000195.

Any help ? thanks..

Re: Problem with export to excel

Former Member — Tue, 28 Nov 2006 03:55:22 GMT

I tried that and now the width is set to 11 characters. but it still doesn't work .

Re: Problem with export to excel

Former Member — Tue, 28 Nov 2006 04:22:19 GMT

Hi,

You can try the option of freezing the column width. i tries on my alv . its working

hope it will help you out.

Regards,

vamsi

Re: Problem with export to excel

Former Member — Tue, 28 Nov 2006 04:24:30 GMT

Hi,, i tried that as well, but without success...

Thanks