GetColumnSortIndicator Method

Visual Basic
C#

'Declaration
 
Public Function GetColumnSortIndicator( _
   ByVal column As Integer _
) As SortIndicator

'Usage
 
Dim instance As SheetView
Dim column As Integer
Dim value As SortIndicator
 
value = instance.GetColumnSortIndicator(column)

public SortIndicator GetColumnSortIndicator( 
   int column
)

Parameters

column: Column index

Return Value

SortIndicator setting that determines how the sort indicator is displayed

This example creates a SheetView object and a Column object. Values are inserted into the second column and in a button click event the column data is sorted and the sort indicator appears. The type of indicator to display is returned to a list box using the SheetView object.

C#

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

FarPoint.Web.Spread.Column mycol;
FarPoint.Web.Spread.SheetView sv = FpSpread1.ActiveSheetView;
mycol = sv.Columns[1];
sv.SetValue(0,1,"Alignment");
sv.SetValue(1,1,"CarbAdjust");
sv.SetValue(2,1,"Brakes");
sv.AllowSort = true;
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 sv As FarPoint.Web.Spread.SheetView
sv = FpSpread1.ActiveSheetView
Dim mycol As FarPoint.Web.Spread.Column
mycol = sv.Columns(1)
sv.SetValue(0,1,"Alignment")
sv.SetValue(1,1,"CarbAdjust")
sv.SetValue(2,1,"Brakes")
sv.AllowSort = True
mycol.SortIndicator = FarPoint.Web.Spread.Model.SortIndicator.Descending
ListBox1.Items.Add(sv.GetColumnSortIndicator(1))
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 10, Windows Vista, Windows Server 2003, Windows Server 2008, Windows Server 2012, Windows XP Professional

Reference

SheetView Class
SheetView Members
SortIndicator Enumeration

User-Task Documentation

Customizing Sorting of Rows of User Data