Blank Line in Excel Heading

[John Lewis]

When I create an Excel spreadsheet from WebFOCUS with headings, there is a blank line that appears after the heading lines and before the report content.  I know this has been a long-standing issue, but I am wondering if there has been any capability added recently in WebFOCUS to keep that blank line from report.  Or, what solutions are available to produce the report without the blank line in the heading?

Thanks!

John

[David Briars]

Does your StyleSheet contain the BORDER attribute?

If so, can you try removing it, and check to see if you no longer see the blank line between the HEADING and the column titles?

 

 

 

Edited August 12 by David Briars

[John Lewis]

I did just add the BORDER attribute to the report, but the blank line was there before I added it.

[Patrick Huebgen]

@John Lewis pleas shre your code if possible a sample with CAR to show the problem

BY the way if you are using an accross - please try 

SET ACROSSLINE=SKIP

 

[John Lewis]

David,

You have it exactly right.  My procedure uses an included stylesheet that contains several BORDER attributes, which is why it had a blank line originally.  I did notice in testing that by simply adding the BORDER attribute, even if it is OFF, the blank line is generated.  

My requirements include use of borders on the report - if I use the BORDER attribute, is there a way to keep that blank line from generating?

If not, I will investigate using HTML5 javascript code in the stylesheet to paint the borders. 

Patrick - David's CAR file code illustrates the issue perfectly.

I will update this post with my findings when I have done some more testing.

[John Lewis]

I am still researching the blank line issue, but am running into another issue with my research.  I would like to use WF Designer to create borders, but am unable to find the functionality to do that.  The documentation refers to a 'Show Border' checkbox in the Format -> General (or Columns) location in Designer, but I see no such checkbox there.  Any idea on why I am not able to access the border functionality in Designer?

[Patrick Huebgen]

Which version of WebFOCUS are you using?

[John Lewis]

We are on version 9.2.3.

[Patrick Huebgen]

On 8/16/2024 at 7:19 PM, John Lewis said:

We are on version 9.2.3.

Should be possible in this version - did you checked the help to see where to find the setting 

https://docs.tibco.com/webfocus/923/doc/html/index.jsp?topic=%2Fcom.ibi.help.intro%2Fsource%2FReport_Styling_8207.htm&cp%3D6_2_5_4

[John Lewis]

The help is where I saw the information regarding the setting, but I do not see it in Designer.  I did not find any picture of where the Show Border checkbox is located, but the help mentions the General or Columns options.  I have attached a couple of screenshots to illustrate what I see on each of those options.  I am using the Grid format for my report. 

[John Lewis]

As a followup to the previous posts on this topic, I have not been able to find a solution for the blank line issue.  My customer says it is acceptable as is, so I will not pursue this any further.