AutoFilterColumn Methods
Provides filtering functionality for a column.Name | Description |
---|---|
ApplyCustomFilter(FilterValue, FilterComparisonOperator, FilterValue, FilterComparisonOperator, Boolean) | Applies a custom filter based on the compound filter expression. |
ApplyCustomFilter(FilterValue, FilterComparisonOperator) | Applies a custom filter based on the specified filter value and comparison operator. |
ApplyDynamicFilter(DynamicFilterType) | Applies a dynamic filter that shows dates that fall within a specified time period or displays values that are above or below the average. |
ApplyFillColorFilter(Color) | Applies the background color filter. |
ApplyFillFilter(Fill) | Applies a filter by cell fill pattern. |
ApplyFilterCriteria(FilterValue, IList<DateGrouping>) | Filters data by cell values and DateTime values. |
ApplyFilterCriteria(FilterValue) | Filters data by values. |
ApplyFilterCriteria(IList<DateGrouping>) | Filters data by a list of date and time values. |
ApplyFontColorFilter(Color) | Applies the font color filter. |
ApplyTop10Filter(Top10Type, Int32) | Applies the "Top 10" filter that displays top/bottom ranked values. |
Clear() | Removes a filter from a specified column. |
See Also