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

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