ColHeadersAutoText Property
Applies To
fpSpread control
Description
Sets or returns whether the column header displays letters or numbers or is blank.
Syntax
long CSpreadSheet::GetColHeadersAutoText( );
void CSpreadSheet::SetColHeadersAutoText(long value);
[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:
|
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)
See Also
Specifying Header Content Type
Customizing Headers for Bound Sheets
ColHeadersAutoTextIndex, ColHeadersShow, RowHeadersAutoText, Sheet, Text, Value properties
DLL Correspondence
SSGetColHeaderDisplay, SSSetColHeaderDisplay functions