AllowAutoFilter Property

Gets or sets whether this column allows automatic filtering.

Syntax

Visual Basic
C#

'Declaration
 
Public Property AllowAutoFilter As Boolean

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

public bool AllowAutoFilter {get; set;}

Property Value

Boolean: true to allow automatic filtering; false otherwise

Remarks

If this value is true, this allows a column to have a default filter assigned to it, which allows the user to filter the rows based on all the possible values in this column. A filter indicator is shown in the header cell of this column and the filter list includes all the unique values in cells in this column.

Example

This example allows a filter to be automatically set on the second column.

fpSpread1.ActiveSheet.Columns[1].AllowAutoFilter = true;

Visual Basic

FpSpread1.ActiveSheet.Columns(1).AllowAutoFilter = True

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

Reference

Column Class
Column Members