Sorts a range of cells in the data model.
Syntax
Parameters
- row
- Starting sheet row index
- column
- Starting sheet column index
- rowCount
- Number of rows in the sheet to sort
- columnCount
- Number of columns in the sheet to sort
- byRows
- Whether the sort should move rows in the range (true) or columns in the range (false)
- sortInfo
- Array of SortInfo objects containing the column indexes (if byRows is true) or row indexes (if byRows is false) and the order of sorting
Return Value
true if successful; otherwise
false
Example
This example illustrates the use of this member by setting the range of cells for the sort.
C# | Copy Code |
---|
FarPoint.Web.Spread.SheetView sv;
FarPoint.Web.Spread.SortInfo[] s = new FarPoint.Web.Spread.SortInfo[1];
s[0] = new FarPoint.Web.Spread.SortInfo(0, false);
sv = FpSpread1.ActiveSheetView;
sv.Sort(0, 0, 3, 1, true, s);
|
Visual Basic | Copy Code |
---|
Dim sv As FarPoint.Web.Spread.SheetView
Dim s(1) As FarPoint.Web.Spread.SortInfo
s(0) = New FarPoint.Web.Spread.SortInfo(0, False)
sv = FpSpread1.ActiveSheetView
sv.Sort(0, 0, 3, 1, True, s) |
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