Name | Description | |
---|---|---|
BlankItem | Indicates a blank item in the filter. |
The following tables list the members exposed by RowFilterBase.
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. |
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. |