Visual Basic (Declaration) | |
---|---|
Public Property Ascending As Boolean |
Visual Basic (Usage) | Copy Code |
---|---|
Dim instance As SortInfo Dim value As Boolean instance.Ascending = value value = instance.Ascending |
C# | |
---|---|
public bool Ascending {get; set;} |
Property Value
Boolean: true for ascending order of sorting; false for descendingThis 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