Syntax
| Visual Basic (Declaration) | |
|---|---|
Public Sub SetColumnSortIndicator( _ ByVal column As Integer, _ ByVal order As SortIndicator _ ) | |
| Visual Basic (Usage) |  Copy Code |
|---|---|
Dim instance As SheetView Dim column As Integer Dim order As SortIndicator instance.SetColumnSortIndicator(column, order) | |
| C# | |
|---|---|
public void SetColumnSortIndicator( int column, SortIndicator order ) | |
Parameters
- column
- Column index
- order
- SortIndicator enumeration setting
Remarks
The SheetView.SetColumnShowSortIndicator method and the Column.ShowSortIndicator property set whether the column shows the sort indicator the next time that the SheetView.AutoSortColumns method is called for that column. It has no effect until AutoSortColumns is called for that column index.
If you want to change the sort indicator shown for a column, use the SheetView.SetColumnSortIndicator method or the Column.SortIndicator property. These change the sort indicator in the column header and do not affect whether the column is sorted or not.
Example
This example illustrates the use of this member by returning the sort indicator for the specified column header.
| C# | Copy Code |
|---|---|
fpSpread1.ActiveSheet.SetColumnSortIndicator(0, FarPoint.Win.Spread.Model.SortIndicator.Descending); FarPoint.Win.Spread.Model.SortIndicator si; si = fpSpread1.ActiveSheet.GetColumnSortIndicator(0); listBox1.Items.Add(si.ToString()); | |
| Visual Basic | Copy Code |
|---|---|
FpSpread1.ActiveSheet.SetColumnSortIndicator(0, FarPoint.Win.Spread.Model.SortIndicator.Descending) Dim si As FarPoint.Win.Spread.Model.SortIndicator si = FpSpread1.ActiveSheet.GetColumnSortIndicator(0) ListBox1.Items.Add(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