AutoText Property (ColumnHeader)

Gets or sets a value that indicates whether the header displays letters or numbers or is blank.

Syntax

Visual Basic
C#

'Declaration
 
<System.ComponentModel.DefaultValueAttribute()>
Public Overrides NotOverridable Property AutoText As HeaderAutoText

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

[System.ComponentModel.DefaultValue()]
public override HeaderAutoText AutoText {get; set;}

Property Value

A value that indicates what the header displays. The default value is Letters.

Example

This example uses the AutoText property.

gcSpreadSheet1.Sheets[0].ColumnHeader.RowCount = 2;
gcSpreadSheet1.Sheets[0].RowHeader.ColumnCount = 2;
gcSpreadSheet1.Sheets[0].ColumnHeader.Cells(0, 2).Text = "Column";
gcSpreadSheet1.Sheets[0].RowHeader.AutoTextIndex = 1;
gcSpreadSheet1.Sheets[0].RowHeader.AutoText = GrapeCity.Windows.SpreadSheet.Data.HeaderAutoText.Letters;
gcSpreadSheet1.Sheets[0].ColumnHeader.AutoTextIndex = 1;
gcSpreadSheet1.Sheets[0].ColumnHeader.AutoText = GrapeCity.Windows.SpreadSheet.Data.HeaderAutoText.Numbers;
gcSpreadSheet1.Invalidate();

VB.NET

GcSpreadSheet1.Sheets(0).ColumnHeader.RowCount = 2
GcSpreadSheet1.Sheets(0).RowHeader.ColumnCount = 2
GcSpreadSheet1.Sheets(0).ColumnHeader.Cells(0, 2).Text = "Column"
GcSpreadSheet1.Sheets(0).RowHeader.AutoTextIndex = 1
GcSpreadSheet1.Sheets(0).RowHeader.AutoText = GrapeCity.Windows.SpreadSheet.Data.HeaderAutoText.Letters
GcSpreadSheet1.Sheets(0).ColumnHeader.AutoTextIndex = 1
GcSpreadSheet1.Sheets(0).ColumnHeader.AutoText = GrapeCity.Windows.SpreadSheet.Data.HeaderAutoText.Numbers
GcSpreadSheet1.Invalidate()

Requirements

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

Reference

ColumnHeader Class
ColumnHeader Members