Sorts all the rows in the sheet according to the specified parameters.
Syntax
| Visual Basic (Usage) |  Copy Code |
|---|
Dim instance As SheetView
Dim keyColumn As Integer
Dim ascending As Boolean
Dim showIndicator As Boolean
Dim comparer As IComparer
Dim value As Boolean
value = instance.SortRows(keyColumn, ascending, showIndicator, comparer) |
Parameters
- keyColumn
- Column whose values are compared during sorting
- ascending
- Whether the sort is ascending
- showIndicator
- Whether to display the sort indicator
- comparer
- IComparer object used to compare the values
Return Value
true if successful; otherwise
false
Remarks
Example
This example illustrates the use of this member by sorting the rows with the specified parameters.
| 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.SortRows(0, false, true, System.Collections.Comparer.Default);
|
| 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.SortRows(0, False, True, System.Collections.Comparer.Default) |
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
