[SOLVED] Does border features work with EXL2K format?
Hi,
I tried to put border in the report with EXL2K format, but it never worked. Can anyone tell me that does border features work with EXL2K format?This message has been edited. Last edited by: Kerry,
May
WebFOCUS 7.6.8 Servlet - MRE/BID/Self Service/ReportCaster - MS Windows Server 2003 - MS SQL Server 2005 - DataMigrator 7.6.9
February 15, 2012, 09:20 AM
Tom Flynn
This works in 7.6.11, don't know about 7.6.8. I do know there were quite a few HotFixes for 7.6.8...
TABLE FILE CAR
PRINT *
ON TABLE PCHOLD FORMAT EXL2K
ON TABLE SET STYLE *
UNITS=IN, FONT=ARIAL, TOPMARGIN=.35, BOTTOMMARGIN=.35,$
TYPE=REPORT, TITLETEXT='EXCEL with Borders', BORDER=1,$
TYPE=TITLE, BORDER=1,$
ENDSTYLE
END
-EXIT
WebFOCUS 7.6.8 Servlet - MRE/BID/Self Service/ReportCaster - MS Windows Server 2003 - MS SQL Server 2005 - DataMigrator 7.6.9
February 15, 2012, 09:37 AM
njsden
May, support for borders in EXL2K output format was introduced in WF 7.6.9.
quote:
Excel (EXL2K Format) Style Enhancements
The StyleSheet options ORIENTATION=LANDSCAPE and BORDER=ON are now supported for EXL2K report output. The BORDER attribute supports the same options as currently available for FORMAT PDF except for border options available in Adobe PDF but not available in Microsoft Excel: Border line width. Excel 2003 does not have an option for specifying a number to precisely set the border line width (thickness) in points. Borders with grooves and ridges. Excel 2003 does not have an option for specifying grooved or ridged borders.
Source: WebFOCUS New Features 7.6.9 (DN# 4500927.0509)
So, about your last question I'm afraid the answer is "No".
You can go around it by *not* using EXL2K, but creating instead an HTML document and alter the MIME type to open it up with Excel 2003.
See this for instance:
TABLE FILE CAR
SUM SALES AND DEALER_COST AND RETAIL_COST
BY COUNTRY
BY CAR
ON TABLE HOLD AS HREPORT FORMAT HTMTABLE
ON TABLE SET PAGE NOPAGE
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
TYPE=REPORT, BORDER=LIGHT, $
ENDSTYLE
END
-RUN
SET HTMLFORMTYPE = XLS
-HTMLFORM BEGIN
<html><body>!IBI.FIL.HREPORT;</body></html>
-HTMLFORM END
The approach above may have some limitations such as no support for EXL2K particular WebFOCUS features (EXL2K FORMULA, PIVOT, TOC, etc.) as it is not an Excel document anymore but an HTML one. However, if you don't use any of those this may be a solution worth trying.