[CLOSED] Unable to get borders in all cells for header with multiple lines in WF8

January 05, 2018, 04:38 PM

Hi I'm struggling trying to get a border around each cell in EXL07 in WF8. There has to be a way to do this, but I can't seem to find a solution.

 
SET DROPBLNKLINE=ALL
TABLE FILE CAR
PRINT
	CAR NOPRINT
HEADING
"<+0> <+0> <+0>Row 1, 1<+0>Row 1, 2<+0> <+0> <+0> <+0>"
"<+0> <+0> <+0>Row 2, 1<+0>Row 2, 2<+0> <+0> <+0> <+0>"
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT EXL07
ON TABLE SET STYLE *
     UNITS=IN, PAGESIZE='Tabloid', ORIENTATION=LANDSCAPE, FONT='ARIAL', SIZE=9, SQUEEZE=ON, $
TYPE=REPORT, GRID=OFF, FONT='ARIAL', SIZE=9, STYLE=NORMAL, LEFTGAP=0.05, RIGHTGAP=0.05, TOPGAP=0.051, BOTTOMGAP=0.051,$
TYPE=HEADING, HEADALIGN=BODY, BORDER=LIGHT, $
TYPE=HEADING, LINE=1, OBJECT=TEXT, ITEM=1, COLSPAN=1, $
TYPE=HEADING, LINE=1, OBJECT=TEXT, ITEM=2, COLSPAN=1, $
TYPE=HEADING, LINE=1, OBJECT=TEXT, ITEM=3, COLSPAN=5, JUSTIFY=CENTER, STYLE=BOLD, $
TYPE=HEADING, LINE=1, OBJECT=TEXT, ITEM=4, COLSPAN=5, JUSTIFY=CENTER, STYLE=BOLD, $
TYPE=HEADING, LINE=1, OBJECT=TEXT, ITEM=5, COLSPAN=1, $
TYPE=HEADING, LINE=1, OBJECT=TEXT, ITEM=6, COLSPAN=1, $
TYPE=HEADING, LINE=1, OBJECT=TEXT, ITEM=7, COLSPAN=1, $
TYPE=HEADING, LINE=2, OBJECT=TEXT, ITEM=1, COLSPAN=1, $
TYPE=HEADING, LINE=2, OBJECT=TEXT, ITEM=2, COLSPAN=1, $
TYPE=HEADING, LINE=2, OBJECT=TEXT, ITEM=3, COLSPAN=5, JUSTIFY=CENTER, STYLE=BOLD, $
TYPE=HEADING, LINE=2, OBJECT=TEXT, ITEM=4, COLSPAN=5, JUSTIFY=CENTER, STYLE=BOLD, $
TYPE=HEADING, LINE=2, OBJECT=TEXT, ITEM=5, COLSPAN=1, $
TYPE=HEADING, LINE=2, OBJECT=TEXT, ITEM=6, COLSPAN=1, $
TYPE=HEADING, LINE=2, OBJECT=TEXT, ITEM=7, COLSPAN=1, $
ENDSTYLE
END

This message has been edited. Last edited by: FP Mod Chuck,

January 08, 2018, 10:14 AM

Francis Mariani

Which WebFOCUS 8 are you trying this on? According to this article, borders started working on v8.0.09.

EXL07/XLSX Format Supported Features Release Roadmap

January 09, 2018, 11:24 AM

Teri Newton

quote:

 TYPE=HEADING, HEADALIGN=BODY, BORDER=LIGHT, $

I thought the border attribute was more like...

 TYPE=HEADING, HEADALIGN=BODY, BORDER-TOP=LIGHT, BORDER-BOTTOM=LIGHT, BORDER-LEFT=LIGHT, BORDER-RIGHT=LIGHT, $

January 09, 2018, 12:48 PM

Francis Mariani

BORDER will take of top, right, bottom, left - just like in CSS.