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


In This Topic
    FilterBar Property
    In This Topic
    Gets the FilterBar object of the sheet.
    Syntax
    'Declaration
     
    Public ReadOnly Property FilterBar As FilterBar
    'Usage
     
    Dim instance As SheetView
    Dim value As FilterBar
     
    value = instance.FilterBar
    public FilterBar FilterBar {get;}
    Example
    This example uses the FilterBar 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