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 for sort; false for descending orderC# | Copy Code |
---|---|
FarPoint.Win.Spread.SortInfo[] sort = new FarPoint.Win.Spread.SortInfo[1]; sort[0] = new FarPoint.Win.Spread.SortInfo(0, true, System.Collections.Comparer.Default); bool b; int i; System.Collections.Comparer; sort[0] = New FarPoint.Win.Spread.SortInfo(0, True, System.Collections.Comparer.Default) b = sort[0].Ascending c = sort[0].Comparer i = sort[0].Index fpSpread1.ActiveSheet.SetValue(0, 0, "S"); fpSpread1.ActiveSheet.SetValue(0, 1, "E"); fpSpread1.ActiveSheet.SetValue(0, 2, "A"); fpSpread1.ActiveSheet.SetValue(0, 3, "K"); fpSpread1.ActiveSheet.SetValue(1, 0, "W"); fpSpread1.ActiveSheet.SetValue(1, 1, "G"); fpSpread1.ActiveSheet.SetValue(1, 2, "P"); fpSpread1.ActiveSheet.SetValue(1, 3, "V"); fpSpread1.ActiveSheet.SetValue(2, 0, "O"); fpSpread1.ActiveSheet.SetValue(2, 1, "L"); fpSpread1.ActiveSheet.SetValue(2, 2, "Q"); fpSpread1.ActiveSheet.SetValue(2, 3, "H"); fpSpread1.ActiveSheet.SortColumns(0, 2, sort); label1.Text = "Is the sort ascending is " + b.ToString() + " and the type of comparer is " + Convert.ToString(c) + " and the index is " + i.ToString(); |
Visual Basic | Copy Code |
---|---|
Dim sort(1) As FarPoint.Win.Spread.SortInfo Dim b As Boolean Dim i As Integer Dim c As System.Collections.Comparer sort(0) = New FarPoint.Win.Spread.SortInfo(0, True, System.Collections.Comparer.Default) b = sort(0).Ascending c = sort(0).Comparer i = sort(0).Index FpSpread1.ActiveSheet.SetValue(0, 0, "S") FpSpread1.ActiveSheet.SetValue(0, 1, "E") FpSpread1.ActiveSheet.SetValue(0, 2, "A") FpSpread1.ActiveSheet.SetValue(0, 3, "K") FpSpread1.ActiveSheet.SetValue(1, 0, "W") FpSpread1.ActiveSheet.SetValue(1, 1, "G") FpSpread1.ActiveSheet.SetValue(1, 2, "P") FpSpread1.ActiveSheet.SetValue(1, 3, "V") FpSpread1.ActiveSheet.SetValue(2, 0, "O") FpSpread1.ActiveSheet.SetValue(2, 1, "L") FpSpread1.ActiveSheet.SetValue(2, 2, "Q") FpSpread1.ActiveSheet.SetValue(2, 3, "H") FpSpread1.ActiveSheet.SortColumns(0, 2, sort) Label1.Text = "Is the sort ascending is " & b.ToString() & " and the type of comparer is " & Convert.ToString(c) & " and the index is " & i.ToString() |
Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2