Focal Point
[CLOSED] how to do colspan with excel out

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/1357022426

September 18, 2012, 11:19 AM
jlsnyc
[CLOSED] how to do colspan with excel out
When using subfoot the value fits into one column, which the value is long, need to do a colspan like in HTML output

This message has been edited. Last edited by: Kerry,
September 21, 2012, 11:44 AM
Kerry
Hi jlsnyc,

Can you please show us your some sample code of what you are trying to do?

Thanks,
Kerry


Kerry Zhan
Focal Point Moderator
Information Builders, Inc.
June 30, 2016, 07:59 AM
Ricardo Augusto
I need to COLSPAN a column on XLSX output.

Any help?


WebFOCUS 8.1.05 / APP Studio
July 05, 2016, 08:32 AM
Ricardo Augusto
?


WebFOCUS 8.1.05 / APP Studio
July 05, 2016, 09:15 AM
Francis Mariani
Ricardo, not every one is hard at work at 8:30 E.S.T.
You haven't provided much information - the original post from 2012 was about subfoot, so here is an example:

TABLE FILE CAR
SUM
SALES
WEIGHT
HEIGHT
LENGTH
BY COUNTRY
SUBFOOT
"THIS IS A LONGER SUBFOOT<+0 AGAIN"
HEADING
"WEBFOCUS REPORT"

ON TABLE SET PAGE NOLEAD
ON TABLE SET STYLE *
TYPE=REPORT, SQUEEZE=ON, FONT='ARIAL',
SIZE=9, $

TYPE=SUBFOOT, HEADALIGN=BODY, $
TYPE=SUBFOOT, ITEM=1, COLSPAN=3, COLOR=RED, $
ENDSTYLE

ON TABLE PCHOLD FORMAT XLSX
END



Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server