Hi,

I am generating report in XLSX format using WebFOCUS 8.1.
There are some heading, applies to report, but these heading are showing with different row height, as compare to data row.

How can I reduce the row height of heading rows? Please suggests.


Thanks,
Sandy Sagar

This message has been edited. Last edited by: FP Mod Chuck,

Should be all about font (styling) used in heading that is larger than data.

Take a look at your styling.

Paste your code and don't forget to add it using the code tag :

</>

Hey Martin,

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,
Sandy

This message has been edited. Last edited by: sandy2sagar,

Perhaps it helps to add TOPGAP=0 to the HEADING style?

I already tried this, by adding TOPGAP to heading, but it is not working.

Please help me here to control row height of heading/footing.

If you try using EXL2K you won't get this issue.

quote:

ON TABLE HEADING
"Sales Summary by Regions"
" "

You are the instigator of this issue with the above code.

Your problem is not that the line height is double, it is that you are introducing an extra blank line in the heading.

If you truly want to control line height in MS Excel then look into using macro enabled templates.

@Dev, This will still happen in EXL2K because of the code used.

T

Actually Tony, sandy2sagar and Dev are right.

If you look at Excel rows 1 and 2 height property it's 18.5 where rows 3 and following are at 12.75 and it does not happen using EXL2K : all rows have the same height.

But I do agree with you that a macro and/or a template must be used since it seems that Focus Excel 2007 (XLSX) heading default height is generated wider than data lines.

Hi Martin,

I was not interpreting his question that way

If what you suggest is the issue, then it can be resolved using styling - well reasonably so - using the font size.

ON TABLE SET STYLE *
SIZE=8, $
TYPE=HEADING, HEADALIGN=BODY, $ 
TYPE=HEADING, LINE=1, ITEM=1, COLSPAN=5, SIZE=10, JUSTIFY=CENTER, COLOR=RGB(179 35 24), $
TYPE=HEADING, LINE=2, ITEM=1, COLSPAN=5, SIZE=5, $
ENDSTYLE

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.

T

quote:

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.

quote:

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
SUM DOLLARS
BY REGION
BY CATEGORY
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 *
SIZE=10, $
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, $
ENDSTYLE
END
-RUN

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.

I have found a simple solution to this problem by adding WRAP=OFF in the Style Sheet:

TYPE=HEADING, HEADALIGN=BODY, WRAP=OFF, $

I hope this helps!