ShowSortIndicator Property

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

Syntax

Visual Basic
C#

'Declaration
 
Public Property ShowSortIndicator As Boolean

'Usage
 
Dim instance As Column
Dim value As Boolean
 
instance.ShowSortIndicator = value
 
value = instance.ShowSortIndicator

public bool ShowSortIndicator {get; set;}

Property Value

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

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.

Example

This example specifies whether the column displays a sort indicator.

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 Basic

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

Reference

Column Class
Column Members
SortIndicator Property
SetColumnShowSortIndicator Method (SheetView)

User-Task Documentation

Managing Sorting