As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Moving forward, myibi is our community platform to learn, share, and collaborate. We have the same Focal Point forum categories in myibi, so you can continue to have all new conversations there. If you need access to myibi, contact us at firstname.lastname@example.org and provide your corporate email address, company, and name.
I am using font size 10 for heading whereas it is 8 for report data. My code is: > TABLE FILE GGSALES SUM DOLLARS/D12.2 AS 'D12.2' DOLLARS/D12C AS 'D12C' DOLLARS/D12CM AS 'D12CM' BY REGION BY CATEGORY ON TABLE HEADING "Sales Summary by Regions" " " ON TABLE PCHOLD FORMAT XLSX ON TABLE SET BYDISPLAY ON ON TABLE SET HTMLCSS ON ON TABLE SET STYLE * TYPE=HEADING, HEADALIGN=BODY, $ TYPE=HEADING, LINE=1, ITEM=1, COLSPAN=5, JUSTIFY=CENTER, COLOR=RGB(179 35 24), $ ENDSTYLE END >
The output of this code, which gives heading with some extra height (highlighted in BLUE):
Whereas, heading should be like below (same as output in EXL2K):
Hope this will help you to understand my problem.
Thanks, SandyThis message has been edited. Last edited by: sandy2sagar,
This will result in a row height of 18 (24 pixels) for the first heading row and 12.75 (17 pixels) for the second row. It is because there is an alternative size specified for the first heading line. The second one could have any lower size value than the global value (or just not set ).
If you want real control over row height then you have to wrestle control away from MS Excel and use macro enabled templates.
Note that I am using WF 8.1.05 for this example and not 7.6 which I do not have installed.
In FOCUS since 1986
WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2
WebFOCUS App Studio 8.2.06 standalone on Windows 10
Posts: 5694 | Location: United Kingdom | Registered: April 08, 2004
If you want real control over row height then you have to wrestle control away from MS Excel and use macro enabled templates
I do agree with you Tony that a macro / template may/must be used.
This will result in a row height of 18 (24 pixels) for the first heading row and 12.75 (17 pixels) for the second row. It is because there is an alternative size specified for the first heading line. The second one could have any lower size value than the global value (or just not set).
But even without any alternative font, using XLSX or EXL2K doesn't give the same result for heading row height.
Try the following with the two output formats and you'll see that the header row height change :
TABLE FILE GGSALES
ON TABLE HEADING
"Heading Row 1"
"Heading Row 2"
ON TABLE PCHOLD FORMAT XLSX
-*ON TABLE PCHOLD FORMAT EXL2K
-* With or without styling, header row's height is greater than the data rows.
ON TABLE SET STYLE *
TYPE=HEADING, HEADALIGN=BODY, $
TYPE=HEADING, LINE=1, COLSPAN=3, SIZE=8, JUSTIFY=CENTER, COLOR=RGB(179 35 24), $
TYPE=HEADING, LINE=2, COLSPAN=3, SIZE=5, JUSTIFY=CENTER, $
In XLSX the header rows are even more wide than the data rows and their font is smaller. Also even without the styling the header rows are wider than the data ones.
There is something that IB do that is not the same when using EXL2K vs XLSX as per heading formatting.
WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF In Focus since 2007
Posts: 2410 | Location: Montreal Area, Qc, CA | Registered: September 25, 2013