Spread for ASP.NET 9.0 Product Documentation
GetSortIndicator Method (BaseSheetAxisModel)
Example 


Row or column index
Gets the sort indicator for the specified row or column. (This implementation always returns None.)
Syntax
'Declaration
 
Public Overridable Function GetSortIndicator( _
   ByVal index As Integer _
) As SortIndicator
'Usage
 
Dim instance As BaseSheetAxisModel
Dim index As Integer
Dim value As SortIndicator
 
value = instance.GetSortIndicator(index)
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.
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());
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 10, Windows Vista, Windows Server 2003, Windows Server 2008, Windows Server 2012, Windows XP Professional

See Also

Reference

BaseSheetAxisModel Class
BaseSheetAxisModel Members
SetSortIndicator Method

 

 


Copyright © GrapeCity, inc. All rights reserved.