Namespace Telerik.Windows.Documents.Spreadsheet.Model.Filtering

Classes

AutoFilter Manages column-based filtering for a worksheet range, hiding or showing rows based on applied filter criteria.

CellValuesFilterBase Base for filters that evaluate cell values to determine whether rows should be hidden or visible.

CustomFilter Filters rows by comparing cell values against one or two custom criteria using relational operators; use for range-based or multi-condition filtering.

CustomFilterCriteria Defines a single comparison criterion for CustomFilter, specifying a relational operator and target value.

DateGroupItem Defines a date/time grouping criterion for ValuesCollectionFilter, matching values by year, month, day, hour, minute, or second components.

DynamicFilter Filters rows based on dynamic date/time criteria (e.g., Today, This Month, Last Year) or numeric criteria (Above/Below Average); recalculates on each evaluation.

FillColorFilter Filters rows by matching cell background fill color against a specified fill; use for visual grouping in filtered data.

FilterBase<T> Abstract base for filters that evaluate cell properties of type T to determine row visibility; provides property retrieval and copying behavior.

FilteringException Exception thrown when filter operations encounter invalid configurations, unsupported criteria, or operation failures.

ForeColorFilter Filters rows by matching cell text (foreground) color against a specified color; use for visual grouping in filtered data.

TopFilter Filter that displays only the top or bottom N items or percentage of items by numeric value in a column.

ValuesCollectionFilter Filter that displays rows whose cell values match any value in a predefined list of strings, dates, or blank entries.

Interfaces

IFilter Common contract for filters that control row visibility in AutoFilter ranges by evaluating cell values.

Enums

DateTimeGroupingType Specifies the date/time component granularity for DateGroupItem filtering, from year-level down to second-level precision.

DynamicFilterType Specifies the criterion type for DynamicFilter, including relative date periods, specific months/quarters, and average comparisons.

LogicalOperator Logical operators that combine two custom filter criteria into a single filter condition.

TopFilterType Modes for selecting top or bottom items by count or percentage in a TopFilter.