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 that specifies what appears for text in headers

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 numbers.

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

This property does not have an effect unless the Visible property (or the SheetView ColumnHeaderVisible property) is set to true and the column header rows are not hidden.

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

Example

This example changes column header cells to be blank.

fpSpread1.ActiveSheet.ColumnHeader.AutoText = FarPoint.Win.Spread.HeaderAutoText.Blank;

Visual Basic

FpSpread1.ActiveSheet.ColumnHeader.AutoText = FarPoint.Win.Spread.HeaderAutoText.Blank

Requirements

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

Reference

ColumnHeader Class
ColumnHeader Members
AutoTextIndex Property

User-Task Documentation

Customizing the Default Header Labels