AutoText Property (ColumnHeader)

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

Syntax

Visual Basic
C#

'Declaration
 
Public Property AutoText As HeaderAutoText

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

public HeaderAutoText AutoText {get; set;}

Property Value

HeaderAutoText setting

Remarks

If your component displays multiple column headers, set the AutoTextIndex property to specify which column header row contains the automatic text.

This property does not have an effect unless the Visible property is set to true. If the component displays multiple column headers, this property does not have an effect if the row displaying the automatic text (specified by the AutoText property) is hidden.

Use the RowHeader object's AutoText property to specify whether the row headers display letters, numbers, or are blank.

Example

This example sets the column header to have three rows and to display the letters in the second of the three rows in the column header.

FarPoint.Web.Spread.ColumnHeader colhdr;
colhdr = FpSpread1.ActiveSheetView.ColumnHeader;
colhdr.RowCount = 3;                                              //  column header has three rows 
colhdr.AutoText = FarPoint.Web.Spread.HeaderAutoText.Letters;     //  column header displays letters 
colhdr.AutoTextIndex = 1;                                         //  automatic text in second zero-index row

Visual Basic

Dim colhdr As FarPoint.Web.Spread.ColumnHeader
colhdr = FpSpread1.ActiveSheetView.ColumnHeader
colhdr.RowCount = 3                                              ' column header has three rows         
colhdr.AutoText = FarPoint.Web.Spread.HeaderAutoText.Letters     ' column header displays letters
colhdr.AutoTextIndex = 1                                         ' automatic text in second zero-index row

Reference

ColumnHeader Class
ColumnHeader Members
AutoTextIndex Property
Visible Property
AutoText Property
HeaderAutoText Enumeration

User-Task Documentation

Customizing the Appearance of Headers