SortInfo Property (GroupDataModel)

Visual Basic
C#

'Declaration
 
Public ReadOnly Property SortInfo As SortInfo()

'Usage
 
Dim instance As GroupDataModel
Dim value() As SortInfo
 
value = instance.SortInfo

public SortInfo[] SortInfo {get;}

Property Value

SortInfo object containing the sorting information

This example groups the data model.

C#

private void button1_Click(object sender, EventArgs e)
{
FarPoint.Web.Spread.Model.GroupDataModel gm = new FarPoint.Web.Spread.Model.GroupDataModel(FpSpread1.ActiveSheetView.DataModel);
FarPoint.Web.Spread.SortInfo[] sort = new FarPoint.Web.Spread.SortInfo[1];
sort[0] = new FarPoint.Web.Spread.SortInfo(0, true);
gm.Group(sort, System.Collections.Comparer.Default);
FpSpread1.ActiveSheetView.DataModel = gm;

String msg = gm.SortInfo.GetValue(0).ToString();
Response.Write("alert('" + msg + "')");
}

Visual Basic

Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim gm As New FarPoint.Web.Spread.Model.GroupDataModel(FpSpread1.ActiveSheetView.DataModel)
Dim sort(0) As FarPoint.Web.Spread.SortInfo
sort(0) = New FarPoint.Web.Spread.SortInfo(0, True)
gm.Group(sort, System.Collections.Comparer.Default)
FpSpread1.ActiveSheetView.DataModel = gm
String msg = gm.SortInfo.GetValue(0).ToString()
Response.Write("alert('" & msg & "')")
End Sub

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

Reference

GroupDataModel Class
GroupDataModel Members