Sets the sort indicator for the specified row or column.
Syntax
Parameters
- index
- Row or column index
- value
- Value with the SortIndicator enumeration
Example
This example sets and returns the sort indicator for the specified column.
C# | Copy Code |
---|
FarPoint.Win.Spread.Model.DefaultSheetAxisModel dsam = new FarPoint.Win.Spread.Model.DefaultSheetAxisModel(3, FarPoint.Win.Spread.Model.SheetAxisOrientation.Horizontal);
dsam = (FarPoint.Win.Spread.Model.DefaultSheetAxisModel)fpSpread1.ActiveSheet.Models.ColumnAxis;
dsam.SetSortIndicator(0, FarPoint.Win.Spread.Model.SortIndicator.Ascending);
fpSpread1.ActiveSheet.Columns[0].AllowAutoSort = true;
fpSpread1.ActiveSheet.SetText(0, 0, "Uno");
fpSpread1.ActiveSheet.SetText(1, 0, "Dos");
fpSpread1.ActiveSheet.SetText(2, 0, "Tres");
FarPoint.Win.Spread.Model.SortIndicator si;
si = dsam.GetSortIndicator(0);
MessageBox.Show("The sort indicator is " + si.ToString());
|
Visual Basic | Copy Code |
---|
Dim dsam As New FarPoint.Win.Spread.Model.DefaultSheetAxisModel(3, FarPoint.Win.Spread.Model.SheetAxisOrientation.Horizontal)
dsam = FpSpread1.ActiveSheet.Models.ColumnAxis
dsam.SetSortIndicator(0, FarPoint.Win.Spread.Model.SortIndicator.Ascending)
FpSpread1.ActiveSheet.Columns(0).AllowAutoSort = True
FpSpread1.ActiveSheet.SetText(0, 0, "Uno")
FpSpread1.ActiveSheet.SetText(1, 0, "Dos")
FpSpread1.ActiveSheet.SetText(2, 0, "Tres")
Dim si As FarPoint.Win.Spread.Model.SortIndicator
si = dsam.GetSortIndicator(0)
MessageBox.Show("The sort indicator is " & si.ToString()) |
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