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
- Index of column to set
- 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
| 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 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2