Spread Windows Forms 11.0 Product Documentation
AutoFilter Property (SheetView)
Example 


FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > SheetView Class : AutoFilter Property
Gets or sets whether the filter will automatically update for any changes.
Syntax
'Declaration
 
Public Property AutoFilter As Boolean
'Usage
 
Dim instance As SheetView
Dim value As Boolean
 
instance.AutoFilter = value
 
value = instance.AutoFilter
public bool AutoFilter {get; set;}
Remarks
Specifies whether the filter is updated based on changes such as data changes.
Example
This example sets the AutoFilter property.
fpSpread1.Sheets[0].Columns[0, 2].AllowAutoFilter = true;
fpSpread1.Sheets[0].Cells[0, 0].Value = 1;
fpSpread1.Sheets[0].Cells[0, 1].Value = 1;
fpSpread1.Sheets[0].Cells[1, 0].Value = 2;
fpSpread1.Sheets[0].Cells[1, 1].Value = 2;
fpSpread1.Sheets[0].Cells[2, 0].Value = 3;
fpSpread1.Sheets[0].Cells[2, 1].Value = 3;
fpSpread1.Sheets[0].AutoFilterMode = FarPoint.Win.Spread.AutoFilterMode.EnhancedContextMenu;
fpSpread1.Sheets[0].AutoFilter = false;
fpSpread1.Sheets(0).Columns(0, 2).AllowAutoFilter = True
fpSpread1.Sheets(0).Cells(0, 0).Value = 1
fpSpread1.Sheets(0).Cells(0, 1).Value = 1
fpSpread1.Sheets(0).Cells(1, 0).Value = 2
fpSpread1.Sheets(0).Cells(1, 1).Value = 2
fpSpread1.Sheets(0).Cells(2, 0).Value = 3
fpSpread1.Sheets(0).Cells(2, 1).Value = 3
fpSpread1.Sheets(0).AutoFilterMode = FarPoint.Win.Spread.AutoFilterMode.EnhancedContextMenu
fpSpread1.Sheets(0).AutoFilter = False
See Also

Reference

SheetView Class
SheetView Members