AllowAutoSort Property (Column)

Gets or sets whether this column allows automatic sorting.

Syntax

Visual Basic
C#

'Declaration
 
Public Property AllowAutoSort As Boolean

'Usage
 
Dim instance As Column
Dim value As Boolean
 
instance.AllowAutoSort = value
 
value = instance.AllowAutoSort

public bool AllowAutoSort {get; set;}

Property Value

Boolean: true to allow automatic sorting; false otherwise

Example

This example specifies whether a column allows automatic sorting.

FarPoint.Win.Spread.Column col;
col = fpSpread1.ActiveSheet.Columns[0];
fpSpread1.ActiveSheet.Cells[0, 0].Text = "Alignment";
fpSpread1.ActiveSheet.Cells[1, 0].Text = "CarbAdjust";
fpSpread1.ActiveSheet.Cells[2, 0].Text = "Brakes";
col.SortIndicator = FarPoint.Win.Spread.Model.SortIndicator.Descending;
col.ShowSortIndicator = true;
col.AllowAutoSort = true;

Visual Basic

Dim col As FarPoint.Win.Spread.Column
col = fpSpread1.ActiveSheet.Columns(0)
fpSpread1.ActiveSheet.Cells(0, 0).Text = "Alignment"
fpSpread1.ActiveSheet.Cells(1, 0).Text = "CarbAdjust"
fpSpread1.ActiveSheet.Cells(2, 0).Text = "Brakes"
col.SortIndicator = FarPoint.Win.Spread.Model.SortIndicator.Descending
col.ShowSortIndicator = True
col.AllowAutoSort = True

Reference

Column Class
Column Members
ShowSortIndicator Property
SortIndicator Property
SetColumnAllowAutoSort Method (in SheetView)