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 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