ColumnHeaderAutoTextIndex Property

Gets or sets which column header row displays the automatic text when there are multiple column header rows.

Syntax

Visual Basic
C#

'Declaration
 
Public Property ColumnHeaderAutoTextIndex As Integer

'Usage
 
Dim instance As SheetView
Dim value As Integer
 
instance.ColumnHeaderAutoTextIndex = value
 
value = instance.ColumnHeaderAutoTextIndex

public int ColumnHeaderAutoTextIndex {get; set;}

Property Value

Integer column header row index

Remarks

This property is available at run time only.

If you have more than one row of columns, set this property to the number of the row in which you want the automatic text to appear.

Example

This example sets the sheet to have three rows of column headers and sets the first row to display the numbers.

FarPoint.Web.Spread.SheetView sv;
sv = FpSpread1.ActiveSheetView;
sv.ColumnHeader.RowCount = 3;
if(IsPostBack)
{
sv.ColumnHeaderAutoTextIndex = 0;
}

Visual Basic

Dim sv As FarPoint.Web.Spread.SheetView
sv = FpSpread1.ActiveSheetView
sv.ColumnHeader.RowCount = 3
If IsPostBack Then
sv.ColumnHeaderAutoTextIndex = 0
End If

Requirements

Target Platforms: Windows 7, Windows 8, Windows Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6

Reference

SheetView Class
SheetView Members
ColumnHeader.AutoTextIndex Property

User-Task Documentation

Customizing the Appearance of Headers