AutoText Property (RowHeader)

Gets or sets whether the row header displays letters or numbers or is blank.

Syntax

Visual Basic
C#

'Declaration
 
Public Property AutoText As HeaderAutoText

'Usage
 
Dim instance As RowHeader
Dim value As HeaderAutoText
 
instance.AutoText = value
 
value = instance.AutoText

public HeaderAutoText AutoText {get; set;}

Property Value

HeaderAutoText setting that specifies what appears for text in the header

Remarks

The automatic text is the text automatically assigned to header cells by Spread. Use this property to change the automatic text to blank or to letters.

If your header has multiple row header columns, you can specify which header column displays the automatic text by setting the AutoTextIndex property.

This property does not have an effect unless the Visible property (or the SheetView RowHeaderVisible property) is set to true and the row header columns are not hidden.

For more information about automatic text, see Customizing the Default Header Labels.

Example

This example specifies that letters be displayed in the third row header.

Visual Basic

Dim r As FarPoint.Win.Spread.RowHeader
r = FpSpread1.ActiveSheet.RowHeader
r.ColumnCount = 4
r.AutoText = FarPoint.Win.Spread.HeaderAutoText.Letters
r.AutoTextIndex = 2

FarPoint.Win.Spread.RowHeader r;
r = fpSpread1.ActiveSheet.RowHeader;
r.ColumnCount = 4; 
r.AutoText = FarPoint.Win.Spread.HeaderAutoText.Letters;
r.AutoTextIndex = 2;

Requirements

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows Server 2012 R2, Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows 10

Reference

RowHeader Class
RowHeader Members
AutoTextIndex Property

User-Task Documentation

Customizing the Default Header Labels