Showing or Hiding Filter Indicators

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

Using Code

Set the AllowAutoFilter property.
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";

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"

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"