AutoFilter
Manages column-based filtering for a worksheet range, hiding or showing rows based on applied filter criteria.
Definition
Namespace:Telerik.Windows.Documents.Spreadsheet.Model.Filtering
Assembly:Telerik.Windows.Documents.Spreadsheet.dll
Syntax:
public class AutoFilterInheritance: objectAutoFilter
Methods
Removes all filters from all columns and unhides all filtered rows.
public void ClearFilters()Retrieves the filter applied to the specified column, or null if no filter exists on that column.
Reapplies the specified filter to re-evaluate row visibility based on current cell values.
Reapplies the filter on the specified column to re-evaluate row visibility based on current cell values.
public void ReapplyFilter(int relativeColumnIndex)The column index relative to the filter range.
Removes the filter from the specified column and unhides rows that were hidden solely by that filter.
Applies the specified filter to its target column, replacing any existing filter on that column.
Applies multiple filters to the filtered range in a single operation.
public void SetFilters(IEnumerable<IFilter> filters)The filters.
Properties
Gets or sets the range to which filtering is applied, including the header row with column names.
public CellRange FilterRange { get; set; }The range of the filter.