This topic summarizes how the end user can interact with the simple row filtering feature.
Once you have row filtering applied to a column, an indicator appears in the column header as in the following figure:
The column header displays the row filtering indicator, a drop-down arrow symbol. Clicking on this indicator provides a drop-down list of the filter choices. Picking an item from this list causes that filter to be applied and all the rows meeting that condition (in this column) are filtered. The default drop-down list contains all the unique text values in cells in this column. The figure below shows an example of a drop-down list of filters:
Filter List Item | Description |
---|---|
(All) | Include or allow all the rows in this column regardless of content |
[contents] | Include or allow only those rows with this particular cell content in this column |
(Blanks) | Include or allow only rows that have blanks (empty cells) in this column |
(NonBlanks) | Include or allow only rows that have non-blanks (non-empty cells) in this column, in other words any cell that has any content |
You can customize the filter list. For more information, see Customizing the List of Filter Items.
Using Code
Create a named style and then set the style row filter.
Example
This example code sets a style row filter.
C# | ![]() |
---|---|
FpSpread1.ActiveSheetView.AutoFilterMode = FarPoint.Web.Spread.AutoFilterMode.FilterGadget; FarPoint.Web.Spread.NamedStyle instyle = new FarPoint.Web.Spread.NamedStyle(); |
VB | ![]() |
---|---|
FpSpread1.ActiveSheetView.AutoFilterMode = FarPoint.Web.Spread.AutoFilterMode.FilterGadget Dim instyle As New FarPoint.Web.Spread.NamedStyle() |