Spread Windows Forms 8.0 Product Documentation
GetColumnAllowAutoSort Method
Example 


Column index
Gets whether the specified column on this sheet allows automatic sorting.
Syntax
'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.";
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 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8

See Also

Reference

SheetView Class
SheetView Members
SetColumnAllowAutoSort Method

User-Task Documentation

Managing Sorting

 

 


Copyright © GrapeCity, inc. All rights reserved.