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, August 03, 2017, 08:03 AM
BabakNYCWhen 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, August 03, 2017, 10:42 AM
DevTry using HTMLFORM BEGIN !
I faced similar issue, then I used HTMLFORM and applied borders with css.
August 03, 2017, 11:48 PM
getitusing exl07 format fixed it. Thank you for the sugestions