Sets whether the specified column on this sheet allows automatic sorting.
Syntax
| Visual Basic (Usage) |  Copy Code |
|---|
Dim instance As SheetView
Dim column As Integer
Dim allowAutoSort As Boolean
instance.SetColumnAllowAutoSort(column, allowAutoSort) |
Parameters
- column
- Index of the single column that is set
- allowAutoSort
- Whether to allow automatic sorting for the specified column
Remarks
Example
This example illustrates the use of this member by returning whether the specified column allows automatic sorting.
| C# | Copy Code |
|---|
Random r = new Random();
int i;
bool b;
for (i = 0; i <= 200; i++)
{
fpSpread1.ActiveSheet.SetValue(i, 0, r.Next().ToString());
}
fpSpread1.ActiveSheet.SetColumnAllowAutoSort(0, true);
b = fpSpread1.ActiveSheet.GetColumnAllowAutoSort(0);
label1.Text = "GetColumnAllowAutoSort = " + b.ToString() + " - Click on the column header to sort."; |
| Visual Basic | Copy Code |
|---|
Dim r As New Random()
Dim i As Integer
Dim b As Boolean
For i = 0 To 200
FpSpread1.ActiveSheet.SetValue(i, 0, r.Next.ToString())
Next
FpSpread1.ActiveSheet.SetColumnAllowAutoSort(0, True)
b = FpSpread1.ActiveSheet.GetColumnAllowAutoSort(0)
Label1.Text = "GetColumnAllowAutoSort = " & b.ToString() & " - Click on the column header to sort." |
Requirements
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
See Also
