Visual Basic (Declaration) | |
---|---|
Public Property Comparer As IComparer |
Visual Basic (Usage) | Copy Code |
---|---|
Dim instance As SortInfo Dim value As IComparer instance.Comparer = value value = instance.Comparer |
C# | |
---|---|
public IComparer Comparer {get; set;} |
Property Value
IComparer object containing the method for comparingThis 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); si1.Ascending = false; si1.Index = 1; si1.Comparer = System.Collections.Comparer.Default; 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) si1.Ascending = False si1.Index = 1 si1.Comparer = System.Collections.Comparer.Default 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 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