Spread Windows Forms 11.0 Product Documentation
AllowAutoFilter Property
Example 


FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > Column Class : AllowAutoFilter Property
Gets or sets whether this column allows automatic filtering.
Syntax
'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;
fpSpread1.ActiveSheet.Columns(1).AllowAutoFilter = True
See Also

Reference

Column Class
Column Members