ColHeadersAutoText Property

Applies To

fpSpread control

Description

Sets or returns whether the column header displays letters or numbers or is blank.

Syntax

C++

long CSpreadSheet::GetColHeadersAutoText( );
void CSpreadSheet::SetColHeadersAutoText(long value);

Visual Basic

[form.]fpSpread.ColHeadersAutoText[ = setting%]

Remarks

The following settings are available:

Setting	Description	Constant
0 - Blank	Displays blanks in the column header	DispBlank
1 - Display Numbers	Displays numbers in the column header	DispNumbers
2 - Display Letters	(Default) Displays letters in the column header	DispLetters

Notes:

Use the ColHeadersAutoText property with column header cells that do not contain data. If you place data into a column header cell using the Text or Value properties, the value of the Text or Value property overrides any previously applied ColHeadersAutoText property setting.
The Text and Value properties do not return the text in a column or row header cell unless the cell contains data (custom text). The properties do not return the auto text in the header cells.

If your sheet displays multiple column header rows, set the ColHeadersAutoTextIndex property to specify which column header row contains the auto text.

This setting is applied to the current sheet setting unless you first set the Sheet property to specify the sheet for which you are setting the property.

This property does not have an effect unless the ColHeadersShow property is set to True and the column header row is not hidden. If the sheet displays multiple headers, this property does not have an effect if the row displaying the auto text (specified by the ColHeadersAutoTextIndex property) is hidden.

Use the RowHeadersAutoText property to specify whether the row header displays letters, numbers, or is blank.

Spread Designer

Choose the Sheet menu, then the Headers menu, and then the General menu, select the Columns tab, and then choose an item from the Header Styles drop-down list box in the Header Settings dialog box.

Data Type

Integer (Enumerated)

DLL Correspondence

SSGetColHeaderDisplay, SSSetColHeaderDisplay functions