Is it possible to show borders in an Excel format?
No, I don't believe that you can do that with focus.
Thanks, I didn't think so either.
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.
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
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,$
ON TABLE PCHOLD FORMAT EXL97
Thanks, Mickey Grackin.
|Powered by Social Strata|