Filter that displays rows whose cell values match any value in a predefined list of strings, dates, or blank entries.
Definition
Namespace:Telerik.Windows.Documents.Spreadsheet.Model.Filtering
Assembly:Telerik.Windows.Documents.Spreadsheet.dll
Syntax:
public class ValuesCollectionFilter : CellValuesFilterBase, IFilterInheritance: objectFilterBase<ICellValue>CellValuesFilterBaseValuesCollectionFilter
Implements:
Inherited Members
Constructors
Initializes a values filter matching the specified date group items with optional blank inclusion.
public ValuesCollectionFilter(int relativeColumnIndex, IEnumerable<DateGroupItem> dateValues, bool blank)Relative index of the column.
dateValuesIEnumerable<DateGroupItem>The date values.
blankboolThe value indicating whether the cells containing blank values should be shown by the filter.
Initializes a values filter matching the specified date group items, excluding blanks.
public ValuesCollectionFilter(int relativeColumnIndex, IEnumerable<DateGroupItem> dateValues)Relative index of the column.
dateValuesIEnumerable<DateGroupItem>The date values.
Initializes a values filter matching the specified string values with optional blank inclusion.
public ValuesCollectionFilter(int relativeColumnIndex, IEnumerable<string> stringValues, bool blank)Relative index of the column.
stringValuesIEnumerable<string>The string values.
blankboolThe value indicating whether the cells containing blank values should be shown by the filter.
Initializes a values filter matching string values, date group items, and optionally blank cells.
public ValuesCollectionFilter(int relativeColumnIndex, IEnumerable<string> stringValues, IEnumerable<DateGroupItem> dateValues, bool blank)Relative index of the column.
stringValuesIEnumerable<string>The string values.
dateValuesIEnumerable<DateGroupItem>The date values.
blankboolThe value indicating whether the cells containing blank values should be shown by the filter.
Initializes a values filter matching both string and date group items, excluding blanks.
public ValuesCollectionFilter(int relativeColumnIndex, IEnumerable<string> stringValues, IEnumerable<DateGroupItem> dateValues)Relative index of the column.
stringValuesIEnumerable<string>The string values.
dateValuesIEnumerable<DateGroupItem>The date values.
Initializes a values filter matching the specified string values, excluding blanks.
public ValuesCollectionFilter(int relativeColumnIndex, IEnumerable<string> stringValues)Relative index of the column.
stringValuesIEnumerable<string>The string values.
Methods
Retrieves the cell value formatted as a string or DateTime based on the cell's number format for filter comparison.
Evaluates whether the value matches any entry in the string list, date groups, or blank criteria.
Properties
Whether to include rows with empty or whitespace-only cell values in the filtered results.
public bool Blank { get; }The value indicating whether the cells containing blank values should be shown by the filter.
Date group items representing hierarchical date/time criteria (year, month, day) for filtering date-formatted cells.
public IEnumerable<DateGroupItem> DateItems { get; }The date items.
Text values to match against formatted cell content; matching is case-insensitive.
public IEnumerable<string> StringValues { get; }The string values.