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

Glossary Item Box

RowHeadersAutoText Property


See Also    DLL    Example

Applies To

fpSpread control

Description

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

Syntax

C++

long CSpreadSheet::GetRowHeadersAutoText( );
void CSpreadSheet::SetRowHeadersAutoText(long value);

Visual Basic

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

Remarks

The following settings are available:

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

Notes:
  • Use the RowHeadersAutoText property with row header cells that do not contain data. If you place data into a row header cell using the Text or Value properties, the value of the Text or Value property overrides any previously applied RowHeadersAutoText 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 control displays multiple row header columns, set the RowHeadersAutoTextIndex property to specify which row header column 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 RowHeadersShow property is set to True and the row header that contains the auto text is not hidden. If the control displays multiple headers, this property does not have an effect if the column displaying the auto text (specified by the RowHeadersAutoTextIndex property) is hidden.

Use the ColHeadersAutoText property to specify whether the column header displays letters, numbers, or is blank.

Spread Designer

Choose the Sheet menu, then the Headers menu, and then the General menu, select the Rows 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

ColHeadersAutoText, RowHeadersAutoTextIndex, RowHeadersShow, Sheet, Text, Value properties

DLL Correspondence

SSGetRowHeaderDisplay, SSSetRowHeaderDisplay functions

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