SetColumnAllowAutoSort(Int32,Boolean) Method

Sets whether the specified column on this sheet allows automatic sorting.

Syntax

Visual Basic
C#

'Declaration
 
Public Overloads Sub SetColumnAllowAutoSort( _
   ByVal column As Integer, _
   ByVal allowAutoSort As Boolean _
)

'Usage
 
Dim instance As SheetView
Dim column As Integer
Dim allowAutoSort As Boolean
 
instance.SetColumnAllowAutoSort(column, allowAutoSort)

public void SetColumnAllowAutoSort( 
   int column,
   bool allowAutoSort
)

Parameters

column: Column index
allowAutoSort: Whether to allow automatic sorting for the specified column

Remarks

The default is for columns not to allow automatic sorting.

Example

This example illustrates the use of this member by returning whether the specified column allows automatic sorting.

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

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

Reference

SheetView Class
SheetView Members
Overload List