Centering a Column Heading

[LeonelSanchezJr]

How do I center a column heading?
The report is written to Excel 2000.

Thanks,

Leo ;-)

 

[ozi2]

try :
TABLE FILE ..
PRINT ....
ON TABLE SET STYLE *
TYPE=TITLE, JUSTIFY=CENTER,$
ENDSTYLE
ON TABLE PCHOLD FORMAT EXL2K
END

OZ

 

[LeonelSanchezJr]

Thanks, but that would center ALL column headings.
I just need to center some; not all.



Thanks,

Leo ;-)

 

[WFGuru]

If you need to center one line just you can use LINE=n in the stylesheet. If you need part of a line left justified and part centered, that gets a little trickier.

 

[LeonelSanchezJr]

Let's say I have ten (10) Columns, but I only need
columns 3, 5, and 7 centered.

I know how to do that in PDF,
You say, Column = N3 Justify = Center, etc.

But, I don't know how for Excel 2000


Thanks,

Leo ;-)

 

[insipid1991]

This worked for me in Excel 2000:

TABLE FILE ..
PRINT ....
ON TABLE SET STYLE *
TYPE=HEADING, LINE=3, OBJECT=TEXT, JUSTIFY=CENTER, $
TYPE=HEADING, LINE=5, OBJECT=TEXT, JUSTIFY=CENTER, $
TYPE=HEADING, LINE=7, OBJECT=TEXT, JUSTIFY=CENTER, $
ENDSTYLE
ON TABLE PCHOLD FORMAT EXL2K
END

Hope this helps!


Doug

 

[LeonelSanchezJr]

That only works for my Headings; not my column headings.
I have 8 line headings,
then i have my column headings.

I only need to center some of my column headings.


Thanks,

Leo ;-)

 

[insipid1991]

OK. I tiied this and it seemed to work:

TABLE FILE ..
PRINT ....
ON TABLE SET STYLE *
TYPE=TITLE, COLUMN=COLUMN3_NAME, JUSTIFY=CENTER, $
TYPE=TITLE, COLUMN=COLUMN5_NAME, JUSTIFY=CENTER, $
TYPE=TITLE, COLUMN=COLUMN7_NAME, JUSTIFY=CENTER, $
ENDSTYLE
ON TABLE PCHOLD FORMAT EXL2K
END

Try that and let me know if it works.


Doug

Doug