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

This example sets and returns the sort indicator for the specified column.

FarPoint.Win.Spread.Model.ISheetAxisModel isa;
isa = (FarPoint.Win.Spread.Model.ISheetAxisModel)fpSpread1.ActiveSheet.Models.ColumnAxis;
isa.SetSortIndicator(1, FarPoint.Win.Spread.Model.SortIndicator.Descending);
label1.Text = "The sort indicator for column 2 is " + isa.GetSortIndicator(1).ToString();

Visual Basic

Dim isa As FarPoint.Win.Spread.Model.ISheetAxisModel
isa = FpSpread1.ActiveSheet.Models.ColumnAxis
isa.SetSortIndicator(1, FarPoint.Win.Spread.Model.SortIndicator.Descending)
Label1.Text = "The sort indicator for column 2 is " & isa.GetSortIndicator(1).ToString()

Requirements

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows Server 2012 R2, Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows 10

Reference

ISheetAxisModel Interface
ISheetAxisModel Members