Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Spool Spreadsheet Formatting is not align

I have a program which excute a program f9 mode, then i select the output device, then select Format=X_65_200, then save into spool request, after the job finished, i see the graphical datalist in proper format.when i save to file as a spreadshheet i open the spreadsheet in excel, my align is not under separate column, its into single column.Is there anything in write statement to align or X-format or Line_size? please help this

REPORT fica_aging_report NO STANDARD PAGE HEADING

MESSAGE-ID zccs LINE-SIZE 225 LINE-COUNT 65(1).

-


Heading -


FORMAT COLOR COL_HEADING INTENSIFIED OFF.

ULINE.

WRITE: /1(1) '|',

3(17) 'Business Area',

22(13) 'District',

37(4) 'Rate',

43(16) ' < 30 Days',

61(16) ' < 60 Days',

79(16) ' < 90 Days',

98(16) ' < 180 Days',

115(16) ' < 365 Days',

133(16) ' > 365 Days',

151(17) ' Total Due',

169 '|'.

FORMAT RESET.

ULINE.

-


Out put -


WRITE: /1(1) '|',

3(17) w_gsber,

22(13) int_grandsummary-city2,

37(14) int_grandsummary-tariftyp,

43(16) ls_30ar,

61(16) ls_60ar,

79(16) ls_90ar,

98(16) ls_180ar,

115(16) ls_365ar,

133(16) ls_over365ar,

151(17) ls_total,

169 '|'.

Tags:
Not what you were looking for? View more on this topic or Ask a question