As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Moving forward, myibi is our community platform to learn, share, and collaborate. We have the same Focal Point forum categories in myibi, so you can continue to have all new conversations there. If you need access to myibi, contact us at myibi@ibi.com and provide your corporate email address, company, and name.
Hello, I would like add vertical line between the across title. The below code works for HTML format not working for XLSX format. I appreciate any one have different thoughts....
SET ACROSSTITLE = SIDE
TABLE FILE CAR
SUM RETAIL_COST
BY COUNTRY AS ''
ACROSS BODYTYPE AS ' COUNTRY TEST' AND COMPUTE NEW= C1 + C3 ;
-*ON TABLE PCHOLD FORMAT HTML
ON TABLE PCHOLD FORMAT XLSX
ON TABLE SET STYLE *
TYPE=REPORT,
IMAGE=IBFS:/WFC/Repository/Verticalline.png,
POSITION=(0.97 0.50),
$
END
-EXIT
This message has been edited. Last edited by: FP Mod Chuck,
Frans, I tried the below code. it did not work either... for the xlsx format. TYPE=ACROSSTITLE, FONT='CALIBRI', STYLE=BOLD, SIZE=11, BORDER-TOP=LIGHT, BORDER-BOTTOM=LIGHT, BORDER-LEFT=LIGHT, BORDER-RIGHT=LIGHT, JUSTIFY=LEFT, $
Rather than ACROSSTITLE, try ACROSSVALUE like this:
SET ACROSSTITLE = SIDE TABLE FILE CAR SUM RETAIL_COST BY COUNTRY AS '' ACROSS BODYTYPE AS ' COUNTRY TEST' AND COMPUTE NEW= C1 + C3 ; ON TABLE PCHOLD FORMAT XLSX ON TABLE SET STYLE * TYPE=ACROSSVALUE, BORDER-LEFT=ON, BORDER-RIGHT=ON, $ END
This worked for me in 8.1.05 and 8.2.01 with MS-Office 2016.
WebFOCUS 8.2.06
Posts: 210 | Location: Sterling Heights, Michigan | Registered: October 19, 2010
Thank you guys for your replies,The reason is I am trying add vertical line between the across title. so it will so as border for the column.Please see the line added before the TEST. it is showing as border. When I print in XLSX.it show little gap at the top.
ACROSS BODYTYPE AS ' COUNTRY |TEST' AND COMPUTE NEW= C1 + C3 ;
@v_ani, did you read the documentation I provided earlier?
quote:
Borders for XLSX does not work in some versions of WebFOCUS. Take a look at WebFOCUS XLSX/EXL07 Format Supported Features Release Roadmap (You'll have to log in to Tech Support).