Spread Windows Forms 13.0 Product Documentation
Spread Windows Forms 13.0 Product Documentation / Developer's Guide / Customizing Row or Column Interaction / Managing Filtering of Rows of User Data / Customizing Simple Filtering / Setting the Appearance of Filter Indicators / Showing or Hiding Filter Indicators
In This Topic
    Showing or Hiding Filter Indicators
    In This Topic

    You can display for the user or hide from the user the filter indicators that appear in the column headers.

    Using Code

    1. Set the AllowAutoFilter property.
    2. Set the ShowFilterIndicator property.

    Example

    This example displays the filter indicator and sets the filter strings.

    C#
    Copy Code
    fpSpread1.ActiveSheet.Columns[1].AllowAutoFilter = true;
    fpSpread1.ActiveSheet.RowFilter.ShowFilterIndicator = true;
    fpSpread1.ActiveSheet.RowFilter.AllString = "Show All";
    fpSpread1.ActiveSheet.RowFilter.BlanksString = "Show The Blanks";
    fpSpread1.ActiveSheet.RowFilter.NonBlanksString = "Show The Non-Blanks";
    VB
    Copy Code
    fpSpread1.ActiveSheet.Columns(1).AllowAutoFilter = True
    fpSpread1.ActiveSheet.RowFilter.ShowFilterIndicator = True
    fpSpread1.ActiveSheet.RowFilter.AllString = "Show All"
    fpSpread1.ActiveSheet.RowFilter.BlanksString = "Show The Blanks"
    fpSpread1.ActiveSheet.RowFilter.NonBlanksString = "Show The Non-Blanks"
    See Also