FarPoint.Win.Spread
ShowSortIndicator Property
See Also  Example
FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > Column Class : ShowSortIndicator Property


Gets or sets whether the column shows a sort indicator when automatically sorted.

Syntax

Visual Basic (Declaration) 
Public Property ShowSortIndicator As Boolean
Visual Basic (Usage)Copy Code
Dim instance As Column
Dim value As Boolean
 
instance.ShowSortIndicator = value
 
value = instance.ShowSortIndicator
C# 
public bool ShowSortIndicator {get; set;}

Return Value

Boolean: true to display the sort indicator; false to hide the sort indicator

Example

This example specifies whether the column displays a sort indicator.
C#Copy Code
FarPoint.Win.Spread.Column col;
col = fpSpread1.ActiveSheet.Columns[0];
fpSpread1.ActiveSheet.Cells[0, 0].Text = "Alignment";
fpSpread1.ActiveSheet.Cells[1, 0].Text = "CarbAdjust";
fpSpread1.ActiveSheet.Cells[2, 0].Text = "Brakes";
col.SortIndicator = FarPoint.Win.Spread.Model.SortIndicator.Descending;
col.ShowSortIndicator = true;
col.AllowAutoSort = true;
Visual BasicCopy Code
Dim col As FarPoint.Win.Spread.Column
col = FpSpread1.ActiveSheet.Columns(0)
FpSpread1.ActiveSheet.Cells(0, 0).Text = "Alignment"
FpSpread1.ActiveSheet.Cells(1, 0).Text = "CarbAdjust"
FpSpread1.ActiveSheet.Cells(2, 0).Text = "Brakes"
col.SortIndicator = FarPoint.Win.Spread.Model.SortIndicator.Descending
col.ShowSortIndicator = True
col.AllowAutoSort = True

Remarks

The Column.ShowSortIndicator property and the SheetView.SetColumnShowSortIndicator method 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.

See Also