AutoText Property (RowHeader)

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 RowHeader
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 Numbers.

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()

Reference

RowHeader Class
RowHeader Members