Gets or sets which column header row in the sheet displays the sort indicator when there are multiple column header rows.
Syntax
Visual Basic (Declaration) | |
---|
Public Property ColumnHeaderAutoSortIndex As Integer |
Visual Basic (Usage) | Copy Code |
---|
Dim instance As SheetView
Dim value As Integer
instance.ColumnHeaderAutoSortIndex = value
value = instance.ColumnHeaderAutoSortIndex |
C# | |
---|
public int ColumnHeaderAutoSortIndex {get; set;} |
Property Value
Integer index of the row in the column header
Remarks
Example
This example sets the row index in the column headers in which sort indicators are displayed.
C# | Copy Code |
---|
Random r = new Random();
int i, j;
for (i = 0; i<=50; i++)
{
for (j = 0; j<=3; j++)
fpSpread1.ActiveSheet.SetValue(i, j, r.Next(1, 200).ToString());
}
fpSpread1.ActiveSheet.Columns[0].SortIndicator = FarPoint.Win.Spread.Model.SortIndicator.Ascending;
fpSpread1.ActiveSheet.Columns[0].AllowAutoSort = true;
fpSpread1.ActiveSheet.Columns[1].SortIndicator = FarPoint.Win.Spread.Model.SortIndicator.Ascending;
fpSpread1.ActiveSheet.Columns[1].AllowAutoSort = true;
fpSpread1.ActiveSheet.Columns[2].SortIndicator = FarPoint.Win.Spread.Model.SortIndicator.Ascending;
fpSpread1.ActiveSheet.Columns[2].AllowAutoSort = true;
fpSpread1.ActiveSheet.ColumnHeaderRowCount = 3;
fpSpread1.ActiveSheet.ColumnHeaderAutoSortIndex = 1; |
Visual Basic | Copy Code |
---|
Dim r As New Random()
Dim i, j, x As Integer
For i = 0 To 50
For j = 0 To 3
FpSpread1.ActiveSheet.SetValue(i, j, r.Next(1, 200).ToString())
FpSpread1.ActiveSheet.Columns(j).SortIndicator = FarPoint.Win.Spread.Model.SortIndicator.Ascending
FpSpread1.ActiveSheet.Columns(j).AllowAutoSort = True
Next j
Next i
FpSpread1.ActiveSheet.ColumnHeaderRowCount = 3
FpSpread1.ActiveSheet.ColumnHeaderAutoSortIndex = 1 |
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
See Also