Spread Windows Forms 7.0 Product Documentation
Showing or Hiding Filter Indicators
See Also Support Options
Spread Windows Forms 7.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

Glossary Item Box

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

Using Code

Here is an example of hiding the filter indicator in code.

Example

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

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.