| Name | Description | |
|---|---|---|
  | BlankItem | Indicates a blank item in the filter. |
RowFilterBase Class Members
In This Topic
The following tables list the members exposed by RowFilterBase.
Public Fields
Public Properties
| Name | Description | |
|---|---|---|
 | IsFiltered | Gets a value that indicates whether any row is filtered. |
| Range | Gets or sets the cell range for the row filter. |
| Sheet | Gets or sets the sheet. |
| ShowFilterButton | Gets or sets a value that indicates whether to show a filter button. |
Public Methods
| Name | Description | |
|---|---|---|
 | AddAverageFilter | Adds the average filter for the row filter. |
| AddBackgroundFilter | Adds the background filter for the row filter. |
| AddDateFilter | Adds the date filter for the row filter. |
| AddFilterItem | Adds a specified filter to the row filter. |
| AddForegroundFilter | Adds the foreground filter for the row filter. |
| AddNumberFilter | Adds the number filter for the row filter. |
| AddTextFilter | Adds the text filter for the row filter. |
| AddTop10Filter | Adds the top 10 filter for the row filter. |
| Filter | Overloaded. Filters all columns. |
| GetFilterableDataItems | Gets the data that can be filtered and is to be displayed in the drop-down list for the specified column. |
| GetFilteredItems | Gets all the filtered conditions. |
| GetFilterItems | Gets the filters for a specified column. |
| IsColumnFiltered | Determines whether a specified column is filtered. |
| IsRowFilteredOut | Determines whether the specified row is filtered out. |
| ReFilter | Refreshes all the filters. |
| RemoveFilterItems | Removes the specified filter. |
| Reset | Clears all filters. |
| Unfilter | Overloaded. Removes the filter for all columns. |
See Also