Focal Point
Borders in Excel

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

September 28, 2004, 01:53 PM
<kvn>
Borders in Excel
Is it possible to show borders in an Excel format?
September 29, 2004, 01:49 PM
Steve C
No, I don't believe that you can do that with focus.
September 29, 2004, 03:04 PM
<kvn>
Thanks, I didn't think so either.
September 29, 2004, 03:14 PM
mgrackin
I believe you can get borders to appear in a spreadsheet if you utilize the CSS feature in WebFOCUS. I haven't tried this myself but I believe it will respect the border settings with ON TABEL PCHOLD FORMAT EXL2K or one of the Excel HOLD formats. Do a little testing.
September 29, 2004, 03:44 PM
mgrackin
Did a little testing myself and found that the ON TABLE PCHOLD FORMAT EXL97 will show borders in the results. I'm surprised this didn't work with EXL2K. In my previous post I was trying to remember the SET HTMLCSS = ON command. Borders will still show without the SET HTMLCSS command but will not respect the BORDER settings in the StyleSheet.

See the following. Used WF 5.2.5 on Win 2000.

SET HTMLCSS = ON
TABLE FILE CAR
SUM RCOST DCOST
BY COUNTRY
BY CAR
BY MODEL
ON TABLE SET BYDISPLAY ON
ON TABLE SET STYLE *
TYPE=REPORT, SIZE=8, $
TYPE=DATA, BORDER=HEAVY, BORDER-STYLE=DASHED,$
TYPE=TITLE, BACKCOLOR=NAVY, COLOR=YELLOW, STYLE=BOLD,$
ENDSTYLE
ON TABLE PCHOLD FORMAT EXL97
END
September 29, 2004, 08:22 PM
<kvn>
Thanks, Mickey Grackin.