Spread for ASP.NET 7.0 Product Documentation
GetSortIndicator Method
See Also  Example Support Options
FarPoint.Web.Spread Assembly > FarPoint.Web.Spread.Model Namespace > BaseSheetAxisModel Class : GetSortIndicator Method


index
Row or column index

Glossary Item Box

Gets the sort indicator for the specified row or column. (This implementation always returns None.)

Syntax

Visual Basic (Declaration) 
Public Overridable Function GetSortIndicator( _
   ByVal index As Integer _
) As SortIndicator
Visual Basic (Usage)Copy Code
Dim instance As BaseSheetAxisModel
Dim index As Integer
Dim value As SortIndicator
 
value = instance.GetSortIndicator(index)
C# 
public virtual SortIndicator GetSortIndicator( 
   int index
)

Parameters

index
Row or column index

Return Value

This one returns None.

Example

This example returns the sort indicator for the specified column.
C#Copy Code
DataTable tblMain = new DataTable();
int i;
tblMain = new DataTable();
tblMain.Columns.Add("ColA");
tblMain.Columns.Add("ColB");
for (i = 1; i <=99; i++)
{
   DataRow r = tblMain.NewRow();
   r[0] = "A " + i.ToString();
   r[1] = "B " + i.ToString();
   tblMain.Rows.Add(r);
}
FpSpread1.DataSource = tblMain;
FpSpread1.ActiveSheetView.AllowSort = true;
 
FarPoint.Web.Spread.Model.BaseSheetAxisModel b;
FarPoint.Web.Spread.Model.SortIndicator si;
b = (FarPoint.Web.Spread.Model.BaseSheetAxisModel)FpSpread1.ActiveSheetView.ColumnAxisModel;
b.SetSortIndicator(0, FarPoint.Web.Spread.Model.SortIndicator.Descending);
si = b.GetSortIndicator(0);
Response.Write(si.ToString());
Visual BasicCopy Code
Dim tblMain As New DataTable
Dim i As Integer
tblMain = New DataTable
tblMain.Columns.Add("ColA")
tblMain.Columns.Add("ColB")
For i = 1 To 99
   Dim r As DataRow = tblMain.NewRow()
   r(0) = "A " + i.ToString()
   r(1) = "B " + i.ToString()
   tblMain.Rows.Add(r)
Next i
FpSpread1.DataSource = tblMain
FpSpread1.ActiveSheetView.AllowSort = True

Dim b As FarPoint.Web.Spread.Model.BaseSheetAxisModel
Dim si As FarPoint.Web.Spread.Model.SortIndicator
b = FpSpread1.ActiveSheetView.ColumnAxisModel
b.SetSortIndicator(0, FarPoint.Web.Spread.Model.SortIndicator.Descending)
si = b.GetSortIndicator(0)
Response.Write(si.ToString()) 

Requirements

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

See Also

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.