GrapeCity.Windows.SpreadSheet.Data Namespace : RowFilterBase Class |
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. |
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. |