SortIndicator Property

Visual Basic
C#

'Declaration
 
Public Property SortIndicator As SortIndicator

'Usage
 
Dim instance As Column
Dim value As SortIndicator
 
instance.SortIndicator = value
 
value = instance.SortIndicator

public SortIndicator SortIndicator {get; set;}

Property Value

SortIndicator setting

The sort indicator appears after the data is sorted and appears only in the column by which the data is sorted.

This example creates a Column object for the default active spreadsheet, sets text in the first three rows of the column and in a button click event sorts the data in the column. The sort indicator for the column is displayed after the column is sorted.

C#

private void Page_Load(object sender,System.EventArgs e)
{
if(this.IsPostBack)return;

FarPoint.Web.Spread.Column mycol;
mycol=FpSpread1.ActiveSheetView.Columns[1];
FpSpread1.ActiveSheetView.SetValue(0,1,"Alignment");
FpSpread1.ActiveSheetView.SetValue(1,1,"CarbAdjust");
FpSpread1.ActiveSheetView.SetValue(2,1,"Brakes");
mycol.SortIndicator=FarPoint.Web.Spread.Model.SortIndicator.Descending;
}

private void Button1_Click(object sender,System.EventArgs e)
{
FpSpread1.ActiveSheetView.SortRows(1,true,true);
}

Visual Basic

Private Sub Page_Load(ByVal sender As System.Object,ByVal e As System.EventArgs)Handles MyBase.Load

If(Me.IsPostBack)Then Return

Dim mycol As FarPoint.Web.Spread.Column
mycol=FpSpread1.ActiveSheetView.Columns(1)
FpSpread1.ActiveSheetView.SetValue(0,1,"Alignment")
FpSpread1.ActiveSheetView.SetValue(1,1,"CarbAdjust")
FpSpread1.ActiveSheetView.SetValue(2,1,"Brakes")
mycol.SortIndicator=FarPoint.Web.Spread.Model.SortIndicator.Descending

End Sub

Private Sub Button1_Click(ByVal sender As System.Object,ByVal e As System.EventArgs)Handles Button1.Click
FpSpread1.ActiveSheetView.SortRows(1,True,True)
End Sub

Target Platforms: Windows 7, Windows 8, Windows Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6

Reference

Column Class
Column Members