SetSortIndicator Method (ISheetAxisModel)

Sets the sort indicator for the specified row or column.

Syntax

Visual Basic
C#

'Declaration
 
Sub SetSortIndicator( _
   ByVal index As Integer, _
   ByVal value As SortIndicator _
)

'Usage
 
Dim instance As ISheetAxisModel
Dim index As Integer
Dim value As SortIndicator
 
instance.SetSortIndicator(index, value)

void SetSortIndicator( 
   int index,
   SortIndicator value
)

Parameters

index: Row or column index
value: Sort indicator value

Example

FarPoint.Web.Spread.Model.ISheetAxisModel isa;
isa = (FarPoint.Web.Spread.Model.ISheetAxisModel)FpSpread1.ActiveSheetView.ColumnAxisModel;
isa.SetSortIndicator(0, FarPoint.Web.Spread.Model.SortIndicator.Ascending)
FarPoint.Web.Spread.Model.SortIndicator si = isa.GetSortIndicator(0);
string msg = "The columns sort indicator is " + si.ToString();
Response.Write("<script language='javascript'>alert('" + msg + "')</script>");

Visual Basic

Dim isa As FarPoint.Web.Spread.Model.ISheetAxisModel
isa = FpSpread1.ActiveSheetView.ColumnAxisModel
isa.SetSortIndicator(0, FarPoint.Web.Spread.Model.SortIndicator.Ascending)
Dim si As FarPoint.Web.Spread.Model.SortIndicator = isa.GetSortIndicator(0)
Dim msg As String = "The columns sort indicator is " & si.ToString()
Response.Write("<script language='javascript'>alert('" & msg & "')</script>")

Requirements

Target Platforms: Windows 7, Windows 8, Windows 10, Windows Vista, Windows Server 2003, Windows Server 2008, Windows Server 2012, Windows XP Professional

Reference

ISheetAxisModel Interface
ISheetAxisModel Members

User-Task Documentation

Customizing Sorting of Rows of User Data