Focal Point
[SOLVED] Remove Blank line in Excel

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/6547014786

August 02, 2017, 10:01 PM
getit
[SOLVED] Remove Blank line in Excel
How to remove the blank line between Row4 and Row6.
Row4 is the Heading and Row6 is the column titles. I do not want a blank line between them.


  


TABLE FILE CAR
PRINT
     CAR.ORIGIN.COUNTRY
     CAR.COMP.CAR
     CAR.CARREC.MODEL
     CAR.BODY.BODYTYPE
     CAR.BODY.SEATS
     CAR.BODY.DEALER_COST
     CAR.BODY.RETAIL_COST
     CAR.BODY.SALES
     CAR.SPECS.LENGTH
     CAR.SPECS.WIDTH
     CAR.SPECS.HEIGHT
     CAR.SPECS.WEIGHT
     CAR.SPECS.WHEELBASE
     CAR.SPECS.FUEL_CAP
     CAR.SPECS.BHP
     CAR.SPECS.RPM
     CAR.SPECS.MPG
     CAR.SPECS.ACCEL
     CAR.WARANT.WARRANTY
     CAR.EQUIP.STANDARD
ON TABLE SUBHEAD
"Fare By Rule"
HEADING
"Markets and Discounts"
"<+0> MARKETS <+0> PASSENGER "
ON TABLE SET PAGE OFF
ON TABLE PCHOLD FORMAT EXL2K 
ON TABLE SET BYDISPLAY ON
ON TABLE SET DROPBLNKLINE ON
ON TABLE SET EMPTYREPORT ON
ON TABLE SET STYLE *
$
TYPE=REPORT,
     FONT='CALIBRI',
     SIZE=11,
     COLOR='BLACK',
     STYLE=NORMAL,
	 TITLETEXT=Fare By Rule,
$
TYPE=TITLE,
     FONT='CALIBRI',
     SIZE=11,
     COLOR='WHITE',
     BACKCOLOR=RGB(83 141 213),
     STYLE=BOLD,
	 	 JUSTIFY=CENTER,
$
TYPE=DATA,
	BORDER=.1,
$
TYPE=TABHEADING,
	 FONT='CAMBRIA',
     SIZE=18,
     COLOR=RGB(0 176 80),
	 STYLE=BOLD,
$
TYPE=HEADING,
	HEADALIGN=BODY,
	 FONT='CAMBRIA',
     SIZE=16,
     COLOR=RGB(31 73 125),
	 STYLE=BOLD,
$
TYPE=HEADING,
	LINE=1,
	ITEM=1, 
	COLSPAN=3,
	STYLE=BOLD,
	JUSTIFY=CENTER,
	COLOR=RED,
	     BACKCOLOR=RGB(218 150 148),
$
TYPE=HEADING,
	LINE=2,
	ITEM=1, 
	COLSPAN=3,
	STYLE=BOLD,
	JUSTIFY=CENTER,
	COLOR=RED,
	     BACKCOLOR=RGB(83 141 213),
$
END

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


App Studio Version 8202
windows Platform
SQL Server 2008/2012
August 03, 2017, 08:03 AM
BabakNYC
When I removed this syntax the blank line went away:
TYPE=DATA,
	BORDER=.1,
$


Question: Are your users still using Excel 2000?

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


WebFOCUS 8206, Unix, Windows
August 03, 2017, 10:42 AM
Dev
Try using HTMLFORM BEGIN !

I faced similar issue, then I used HTMLFORM and applied borders with css.


8202, 8105M, 7.7.03
August 03, 2017, 11:48 PM
getit
using exl07 format fixed it. Thank you for the sugestions


App Studio Version 8202
windows Platform
SQL Server 2008/2012