Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Go
New
Search
Notify
Tools
Reply
  
Borders in Excel
 Login/Join
 
<kvn>
posted
Is it possible to show borders in an Excel format?
 
Reply With QuoteReport This Post
Silver Member
posted Hide Post
No, I don't believe that you can do that with focus.
 
Posts: 44 | Location: New York City | Registered: May 23, 2004Reply With QuoteReport This Post
<kvn>
posted
Thanks, I didn't think so either.
 
Reply With QuoteReport This Post
Virtuoso
posted Hide Post
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.
 
Posts: 995 | Location: Gaithersburg, MD, USA | Registered: May 07, 2003Reply With QuoteReport This Post
Virtuoso
posted Hide Post
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
 
Posts: 995 | Location: Gaithersburg, MD, USA | Registered: May 07, 2003Reply With QuoteReport This Post
<kvn>
posted
Thanks, Mickey Grackin.
 
Reply With QuoteReport This Post
  Powered by Social Strata  
 


Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.