Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread Namespace / SheetView Class / AutoFilter Property
Example


In This Topic
    AutoFilter Property (SheetView)
    In This Topic
    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