Martin Yergeau Posted July 4 Share Posted July 4 Hi, As an Excel format, is there a way to reproduce the "Alignment Grid" option without the HEADALIGN=BODY which is set by default ? I am trying to produce a second Excel tab that only contains "documentation" and not a real report. So, I have tried to only includes several HEADING rows where some rows have multiple text data that must by positioned explicitly. In HTML, the display is as expected, but in Excel everything is displayed within one cell per row There is several options in styling (LEFTGAP, RIGHTGAP, POSITION, WIDTH, COLSPAN, ...) but none seems to work with Excel Here what I am trying to reproduce in Excel Link to comment Share on other sites More sharing options...
Solution Martin Yergeau Posted July 4 Author Solution Share Posted July 4 I got it to work using HEADING & FOOTING and combining with dummy data column having the WRAP styling key word DEFINE FILE CAR DUMMY1 /A1 = ''; DUMMY2 /A1 = ''; DUMMY3 /A1 = ''; END TABLE FILE CAR SUM DUMMY1 AS '' BY DUMMY2 AS '' BY DUMMY3 AS '' BY COUNTRY NOPRINT HEADING "324523523523452345234523452345234523452345234523452345" "WGSDGSG45GWRG45TRTGW45TGRT" FOOTING "c1C1C1C1C1C1C1C1C1C1<+0>c2C2C2C2C2C2C2C2C2C2C2C2C2<+0>c3C3C3C3C3C3C3C3C3C3C3C3C3C3C3C3C3C3C3C3C3C3C3C3" "c11<+0>c22<+0>c33" "c111<+0>c222<+0>c333" WHERE RECORDLIMIT EQ 1 ON TABLE SET PAGE-NUM NOLEAD ON TABLE SET ASNAMES ON ON TABLE NOTOTAL ON TABLE PCHOLD FORMAT XLSX ON TABLE SET XLSXPAGESETS ON ON TABLE SET HTMLCSS ON ON TABLE SET STYLE * INCLUDE = IBFS:/EDA/EDASERVE/_EDAHOME/ETC/warm.sty, $ TYPE=REPORT, COLUMN=DUMMY1, WRAP=2, $ TYPE=REPORT, COLUMN=DUMMY2, WRAP=3, $ TYPE=REPORT, COLUMN=DUMMY3, WRAP=6, $ TYPE=FOOTING, HEADALIGN=BODY, $ TYPE=FOOTING, LINE=1, OBJECT=TEXT, ITEM=1, COLSPAN=1, JUSTIFY=LEFT, $ TYPE=FOOTING, LINE=1, OBJECT=TEXT, ITEM=2, COLSPAN=1, JUSTIFY=LEFT, $ TYPE=FOOTING, LINE=1, OBJECT=TEXT, ITEM=3, COLSPAN=1, JUSTIFY=LEFT, $ TYPE=FOOTING, LINE=2, OBJECT=TEXT, ITEM=1, COLSPAN=1, JUSTIFY=LEFT, $ TYPE=FOOTING, LINE=2, OBJECT=TEXT, ITEM=2, COLSPAN=1, JUSTIFY=LEFT, $ TYPE=FOOTING, LINE=2, OBJECT=TEXT, ITEM=3, COLSPAN=1, JUSTIFY=LEFT, $ TYPE=FOOTING, LINE=3, OBJECT=TEXT, ITEM=1, COLSPAN=1, JUSTIFY=LEFT, $ TYPE=FOOTING, LINE=3, OBJECT=TEXT, ITEM=2, COLSPAN=1, JUSTIFY=LEFT, $ TYPE=FOOTING, LINE=3, OBJECT=TEXT, ITEM=3, COLSPAN=1, JUSTIFY=LEFT, $ ENDSTYLE END 1 Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now