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


In This Topic
    DefaultStyle Property (FilterBar)
    In This Topic
    Gets or sets the default style information for the filter bar items in the filter bar.
    Syntax
    'Declaration
     
    Public Property DefaultStyle As StyleInfo
    'Usage
     
    Dim instance As FilterBar
    Dim value As StyleInfo
     
    instance.DefaultStyle = value
     
    value = instance.DefaultStyle
    public StyleInfo DefaultStyle {get; set;}
    Example
    This example uses the DefaultStyle property.
    //Customize "Cells" in Filter Bar
    FarPoint.Win.Spread.SheetView sheetView = fpSpread1.ActiveSheet;
    sheetView.AutoFilterMode = FarPoint.Win.Spread.AutoFilterMode.FilterBar;
    sheetView.FilterBar.Cells[0].Border = new FarPoint.Win.DoubleLineBorder(Color.Red);
    sheetView.FilterBar.Cells[0].BackColor = Color.GreenYellow;
    sheetView.FilterBar.Cells[0].CellType = new FarPoint.Win.Spread.CellType.FilterBarCellType();
    sheetView.FilterBar.DefaultStyle.Border = new FarPoint.Win.DoubleLineBorder(Color.Yellow);
    FarPoint.Win.Spread.CellType.FilterBarCellType cellType = new FarPoint.Win.Spread.CellType.FilterBarCellType();
    cellType.ShowDropDownMenuStrip = false;
    sheetView.FilterBar.Cells[3].CellType = cellType;
    sheetView.FilterBar.Height = 30;
    sheetView.FilterBarHeaderStyle.Border = new FarPoint.Win.DoubleLineBorder(Color.Red);
    sheetView.FilterBarHeaderStyle.BackColor = Color.Yellow;     
    fpSpread1.ActiveSheet.Cells[0, 0, 2, 5].Text = "Test";
    fpSpread1.ActiveSheet.Cells[3, 0, 5, 5].Text = "A";
    'Customize "Cells" in Filter Bar
    Dim sheetView As FarPoint.Win.Spread.SheetView = FpSpread1.ActiveSheet
    sheetView.AutoFilterMode = FarPoint.Win.Spread.AutoFilterMode.FilterBar
    sheetView.FilterBar.Cells(0).Border = New FarPoint.Win.DoubleLineBorder(Color.Red)
    sheetView.FilterBar.Cells(0).BackColor = Color.GreenYellow
    sheetView.FilterBar.Cells(0).CellType = New FarPoint.Win.Spread.CellType.FilterBarCellType()
    sheetView.FilterBar.DefaultStyle.Border = New FarPoint.Win.DoubleLineBorder(Color.Yellow)
    Dim cellType As New FarPoint.Win.Spread.CellType.FilterBarCellType()
    cellType.ShowDropDownMenuStrip = False
    sheetView.FilterBar.Cells(3).CellType = cellType
    sheetView.FilterBar.Height = 30
    sheetView.FilterBarHeaderStyle.Border = New FarPoint.Win.DoubleLineBorder(Color.Red)
    sheetView.FilterBarHeaderStyle.BackColor = Color.Yellow
    FpSpread1.ActiveSheet.Cells(0, 0, 2, 5).Text = "Test"
    FpSpread1.ActiveSheet.Cells(3, 0, 5, 5).Text = "A"
    See Also