alignment in excel sheet is not proper

[Former Member]

hi all,

In my report, there are 3 sections(Newly created POs, Changed POs, Closed POs) with different number of columns.

The report is displayed absolutely fine when it is run in the foreground. But, when it is downloaded into an Excel sheet, there are blank columns in between the fields as the report has 3 different formats for each section. Inside each section, the alignment of columns is fine.

Please, let me know how to suppress the blank columns in between fields.

Thanks & Regards,

Vinny

[Former Member]

Hi,

prepare three internals table for each report and

download in to excel.

Regards

Amole

[Former Member]

Vinny is that the case when you save the list to Spreadsheet..

in that case you need to adjust the way you list the report to start at the same column numbers as the titles(common for all three).

[Former Member]

hi Amole,

Actually i haven't written anything regarding Download.

Instead im downloading the report output using standard spool option.

Regards,

Vinny

[Former Member]

Hi,

You have to handle it manualyy in program

by declaring internal table for your

layout and use MS_EXCEL_OLE_STANDARD_DAT.

regards

amole