Automatically sorts the rows of a sheet according to the specified column in the specified order and shows the sort indicator (unless disabled).
Syntax
| Visual Basic (Usage) |  Copy Code |
|---|
Dim instance As SheetView
Dim column As Integer
Dim ascending As Boolean
instance.AutoSortColumn(column, ascending) |
Parameters
- column
- Index of column to set
- ascending
- Whether sort is ascending (or else descending)
Remarks
Example
This example adds random numbers to the sheet then auto sorts the column in descending order and displays the sort indicator.
| C# | Copy Code |
|---|
Random r = new Random();
int i;
for (i = 0; i <= 200; i++)
{
fpSpread1.ActiveSheet.SetValue(i, 0, r.Next().ToString());
}
fpSpread1.ActiveSheet.AutoSortColumn(0, false); |
| Visual Basic | Copy Code |
|---|
Dim r As New Random()
Dim i As Integer
For i = 0 To 200
FpSpread1.ActiveSheet.SetValue(i, 0, r.Next.ToString())
Next
FpSpread1.ActiveSheet.AutoSortColumn(0, False) |
Requirements
Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8
See Also
