Sets whether the specified columns on this sheet allow automatic sorting.
Syntax
| Visual Basic (Usage) |  Copy Code |
|---|
Dim instance As SheetView
Dim column As Integer
Dim count As Integer
Dim allowAutoSort As Boolean
instance.SetColumnAllowAutoSort(column, count, allowAutoSort) |
Parameters
- column
- Column index of first column to set
- count
- Number of columns to set
- allowAutoSort
- Whether to allow automatic sorting for the specified columns
Exceptions
Remarks
Example
This example specifies if the columns allow automatic sorting.
| C# | Copy Code |
|---|
Random r = new Random();
int i, j;
bool b;
for (i = 0; i <= 200; i++)
{
for (j = 0; j<=3; j++)
fpSpread1.ActiveSheet.SetValue(i, j, r.Next().ToString());
}
fpSpread1.ActiveSheet.SetColumnAllowAutoSort(0, 4, true);
b = fpSpread1.ActiveSheet.GetColumnAllowAutoSort(0);
label1.Text = "GetColumnAllowAutoSort = " + b.ToString() + " - Click on the column headers to sort."; |
| Visual Basic | Copy Code |
|---|
Dim r As New Random()
Dim i, j As Integer
Dim b As Boolean
For i = 0 To 50
For j = 0 To 3
FpSpread1.ActiveSheet.SetValue(i, j, r.Next.ToString())
Next j
Next i
FpSpread1.ActiveSheet.SetColumnAllowAutoSort(0, 4, True)
b = FpSpread1.ActiveSheet.GetColumnAllowAutoSort(0)
Label1.Text = "GetColumnAllowAutoSort = " & b.ToString() & " - Click on the column headers to sort." |
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
