Spread Windows Forms 16
Spread Windows Forms 16.0 Product Documentation / Developer's Guide / Customizing Row or Column Interaction / Managing Filtering of Rows of User Data / Customizing the Filter Bar
In This Topic
    Customizing the Filter Bar
    In This Topic

    You can customize the appearance of the filter bar. You can change the background and text colors and the grid lines and their color. The following figure illustrates a filter bar with a custom appearance.

    Filter bar with a customized appearance

    The filter bar also provides a date picker to pick a date to filter by. Certain filter menu choices will display the date picker (before or after, for example). You can also type the value in the edit portion of the filter after you select a filter menu option.

    Filter bar with a date picker

    Setting the AutoFormat property to true specifies to use the DateTimeFormatInfo, FormatString, and NumberFormatInfo properties to format the value in the filter bar. Set these properties if the format of the data in the cell is different from the format in the filter bar. The Equals filter menu option requires that the cell format and the filter bar format be the same.

    Using Code

    1. To customize specific cells in the filter bar, set the FilterBar class's Cells properties.
    2. To customize the filter bar overall, set the FilterBar's DefaultStyle, Height, HorizontalGridLine, and VerticalGridLine properties.


    The following example sets one cell in the filter bar to display a custom border and background color, and the entire filter bar to display a custom border.

    Copy Code
    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.DefaultStyle.Border = new FarPoint.Win.DoubleLineBorder(Color.Yellow);
    Copy Code
    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.DefaultStyle.Border = New FarPoint.Win.DoubleLineBorder(Color.Yellow)
    See Also