Spread 8.0 Documentation
ColHeadersAutoText Property
Support Options
ActiveX Reference > ActiveX Properties > ColHeadersAutoText Property

Glossary Item Box

ColHeadersAutoText Property


See Also    DLL    Example

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)

See Also

Specifying Header Content Type
Customizing Headers for Bound Sheets

ColHeadersAutoTextIndex, ColHeadersShow, RowHeadersAutoText, Sheet, Text, Value properties

DLL Correspondence

SSGetColHeaderDisplay, SSSetColHeaderDisplay functions

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.