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. |
Protected Methods
| Name | Description | |
|---|---|---|
 | OnAddColumns | Adds columns in the filter after the specified column. |
| OnAddRows | Adds rows in the filter after the specified row. |
| OnClear | Removes filters in the specified range |
| OnCopy | Copies filters from the start range and pastes into a range of cells at the end location. |
| OnMove | Moves filters from the start range to a range of cells at the end location. |
| OnRemoveColumns | Removes columns in the filter from the specified column. |
| OnRemoveRows | Removes rows in the filter from the specified row. |
| OnSwap | Swaps filters of the specified range from one location to another. |
See Also