Spread for ASP.NET 11 Product Documentation
ColumnHeaderAutoTextIndex Property
Example 


FarPoint.Web.Spread Assembly > FarPoint.Web.Spread Namespace > SheetView Class : ColumnHeaderAutoTextIndex Property
Gets or sets which column header row displays the automatic text when there are multiple column header rows.
Syntax
'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;
}
Dim sv As FarPoint.Web.Spread.SheetView
sv = FpSpread1.ActiveSheetView
sv.ColumnHeader.RowCount = 3
If IsPostBack Then
sv.ColumnHeaderAutoTextIndex = 0
End If
See Also

Reference

SheetView Class
SheetView Members
ColumnHeader.AutoTextIndex Property

User-Task Documentation

Customizing the Appearance of Headers