GetColumnAllowAutoSort Method

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

Syntax

Visual Basic
C#

'Declaration
 
Public Function GetColumnAllowAutoSort( _
   ByVal column As Integer _
) As Boolean

'Usage
 
Dim instance As SheetView
Dim column As Integer
Dim value As Boolean
 
value = instance.GetColumnAllowAutoSort(column)

public bool GetColumnAllowAutoSort( 
   int column
)

Parameters

column: Column index

Return Value

Boolean: true if the specified column allows automatic sorting; false otherwise

Remarks

The default is for a column not to allow automatic sorting. Use this method to allow the user to perform automatic sorting of rows by clicking on the sorting indicator in a column header.

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

Requirements

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows Server 2012 R2, Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows 10

Reference

SheetView Class
SheetView Members
SetColumnAllowAutoSort Method

User-Task Documentation

Managing Sorting