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


In This Topic
    AutoFilterMode Property (SheetView)
    In This Topic
    Gets or sets the AutoFilterMode.
    Syntax
    'Declaration
     
    Public Property AutoFilterMode As AutoFilterMode
    'Usage
     
    Dim instance As SheetView
    Dim value As AutoFilterMode
     
    instance.AutoFilterMode = value
     
    value = instance.AutoFilterMode
    public AutoFilterMode AutoFilterMode {get; set;}
    Example
    This example uses the AutoFilterMode property.
    //Basic Filter Bar
    FarPoint.Win.Spread.SheetView sheetView = fpSpread1.ActiveSheet;
    sheetView.AutoFilterMode = FarPoint.Win.Spread.AutoFilterMode.FilterBar;
    sheetView.FilterBar.Height = 30;
    sheetView.FilterBarHeaderStyle.Border = new FarPoint.Win.DoubleLineBorder(Color.Red);
    sheetView.FilterBarHeaderStyle.BackColor = Color.Yellow;  
    'Basic Filter Bar
    Dim sheetView As FarPoint.Win.Spread.SheetView = FpSpread1.ActiveSheet
    sheetView.AutoFilterMode = FarPoint.Win.Spread.AutoFilterMode.FilterBar
    sheetView.FilterBar.Height = 30
    sheetView.FilterBarHeaderStyle.Border = New FarPoint.Win.DoubleLineBorder(Color.Red)
    sheetView.FilterBarHeaderStyle.BackColor = Color.Yellow
    See Also