Problem with export to excel

[Former Member]

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

[Former Member]

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

[Former Member]

The sales order number is in the middle.

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

[anversha_s]

hi,

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

rgds

Anver

[Former Member]

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

[Former Member]

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..

[Former Member]

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

[Former Member]

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

[Former Member]

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

Thanks