[SOLVED] Excel Styling issues.

I have a report requirement to display heading in different cells in EXCEL. Searched forum, IBI Tech forums for sample programs.. But couldn't find any prg.
Below sample example puts the entire heading in single line.

TABLE FILE CAR
HEADING
"DISPLAY 1ST CELL <+0> 2ND CELL"
" "
BY COUNTRY 
ON TABLE PCHOLD FORMAT EXL2K
ON TABLE SET STYLE *
TYPE=HEADING, LINE=1, ITEM=1, OBJECT=TEXT, COLSPAN=1,$
TYPE=HEADING, LINE=1, ITEM=2, OBJECT=TEXT, COLSPAN=1,$
ENDSTYLE
END

Any help suggestion would be appreciated.

Thanks

This message has been edited. Last edited by: <Kathryn Henning>,

Prod: WF 7.6.10 windows. -- MRE/Dashboard/Self Service/ReportCaster - Windows XP

Posts: 82 | Location: Chicago | Registered: September 28, 2005

Danny-SRL

Virtuoso

posted

Hide Post

Try this:

  
DEFINE FILE CAR
SP/A1=' ';
END
TABLE FILE CAR

BY COUNTRY AS 'DISPLAY 1ST CELL,COUNTRY'
BY SP AS '2ND CELL, '
ON TABLE PCHOLD FORMAT EXL2K
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
ENDSTYLE
END

Daniel
In Focus since 1982
wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF

Posts: 1980 | Location: Tel Aviv, Israel | Registered: March 23, 2006

Ignored post by Danny-SRL posted

Show Post

Tony A

Expert

posted

Hide Post

Just use HEADALIGN within the stylesheet -

TABLE FILE CAR
HEADING
"DISPLAY 1ST CELL <+0> 2ND CELL"
" "
BY COUNTRY 
ON TABLE PCHOLD FORMAT EXL2K
ON TABLE SET STYLE *
TYPE=HEADING, HEADALIGN=BODY, $
ENDSTYLE
END