Telerik.Windows.Documents.Spreadsheet.Model.Filtering

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

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

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

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

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

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

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.

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

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

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

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

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

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

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

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

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

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