Visual Basic (Declaration) | |
---|---|
Public Function New( _ ByVal index As Integer, _ ByVal ascending As Boolean, _ ByVal comparer As IComparer _ ) |
Visual Basic (Usage) | Copy Code |
---|---|
Dim index As Integer Dim ascending As Boolean Dim comparer As IComparer Dim instance As New SortInfo(index, ascending, comparer) |
Parameters
- index
- Index of the column or row on which to sort
- ascending
- Whether sort order is ascending
- comparer
- IComparer object for method of comparison
This example sorts the columns using the sort array.
C# | Copy Code |
---|---|
FarPoint.Web.Spread.SortInfo si0 = new FarPoint.Web.Spread.SortInfo(0, true, System.Collections.Comparer.Default); FarPoint.Web.Spread.SortInfo si1 = new FarPoint.Web.Spread.SortInfo(1, true); FarPoint.Web.Spread.SortInfo si2 = new FarPoint.Web.Spread.SortInfo(2, true); FpSpread1.ActiveSheetView.SetValue(0, 0, "D"); FpSpread1.ActiveSheetView.SetValue(1, 0, "F"); FpSpread1.ActiveSheetView.SetValue(2, 0, "E"); FpSpread1.ActiveSheetView.SetValue(0, 1, "A"); FpSpread1.ActiveSheetView.SetValue(1, 1, "C"); FpSpread1.ActiveSheetView.SetValue(2, 1, "B"); FpSpread1.ActiveSheetView.SetValue(0, 2, "G"); FpSpread1.ActiveSheetView.SetValue(1, 2, "I"); FpSpread1.ActiveSheetView.SetValue(2, 2, "H"); FarPoint.Web.Spread.SortInfo[] si = new FarPoint.Web.Spread.SortInfo[] {si0, si1, si2}; FpSpread1.ActiveSheetView.SortColumns(0, 3, si); |
Visual Basic | Copy Code |
---|---|
Dim si0 As New FarPoint.Web.Spread.SortInfo(0, True, System.Collections.Comparer.Default) Dim si1 As New FarPoint.Web.Spread.SortInfo(1, True) Dim si2 As New FarPoint.Web.Spread.SortInfo(2, True) FpSpread1.ActiveSheetView.SetValue(0, 0, "D") FpSpread1.ActiveSheetView.SetValue(1, 0, "F") FpSpread1.ActiveSheetView.SetValue(2, 0, "E") FpSpread1.ActiveSheetView.SetValue(0, 1, "A") FpSpread1.ActiveSheetView.SetValue(1, 1, "C") FpSpread1.ActiveSheetView.SetValue(2, 1, "B") FpSpread1.ActiveSheetView.SetValue(0, 2, "G") FpSpread1.ActiveSheetView.SetValue(1, 2, "I") FpSpread1.ActiveSheetView.SetValue(2, 2, "H") Dim si() As FarPoint.Web.Spread.SortInfo = New FarPoint.Web.Spread.SortInfo() {si0, si1, si2} FpSpread1.ActiveSheetView.SortColumns(0, 3, si) |
Target Platforms: Windows 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family, Windows Vista, Windows Server 2008 family