Spool Spreadsheet Formatting is not align

Former Member — Fri, 26 Sep 2008 22:38:11 GMT

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

Re: Spool Spreadsheet Formatting is not align

Former Member — Wed, 24 Aug 2011 23:29:11 GMT

Users are entering special characters in the instructions to the signatory, and when the string is picked up into the custom email, the system is mis-translating the characters in the CLM.We suspect on the custom java mail util not setting up the MIME Type.

Any help would advise on this.

topic Re: Spool Spreadsheet Formatting is not align in Application Development and Automation Discussions

Spool Spreadsheet Formatting is not align

Re: Spool Spreadsheet Formatting is not align