SpreadValuesFilter
Represents a value-based filter that shows only rows matching specific string values, date groups, or blank cells.
StringValues, DateItems, and Blank are combined with OR logic: a row passes the filter if it matches any of the string values, any of the date items, or the blank condition (when enabled).
Blank match returns true for null cells AND for string cells whose value is the empty string.
String values are matched case-insensitively during filter evaluation. Null strings are rejected at construction time; pass an empty collection instead.
Definition
Namespace:Telerik.Documents.SpreadsheetStreaming
Assembly:Telerik.Documents.SpreadsheetStreaming.dll
Syntax:
public class SpreadValuesFilter : ISpreadFilterInheritance: objectSpreadValuesFilter
Implements:
Constructors
Initializes a new instance of the SpreadValuesFilter class with date group items.
public SpreadValuesFilter(IEnumerable<SpreadDateGroupItem> dateItems)The date group items to match.
Initializes a new instance of the SpreadValuesFilter class with string values and blank option.
public SpreadValuesFilter(IEnumerable<string> stringValues, bool blank)The string values to match.
blankboolWhether to include blank cells.
Initializes a new instance of the SpreadValuesFilter class.
public SpreadValuesFilter(IEnumerable<string> stringValues, IEnumerable<SpreadDateGroupItem> dateItems, bool blank)The string values to match. Can be null.
dateItemsIEnumerable<SpreadDateGroupItem>The date group items to match. Can be null.
blankboolWhether to include blank cells.
Exceptions: ArgumentExceptionThrown when any element of stringValues is null,
or when any element of dateItems is null.
Initializes a new instance of the SpreadValuesFilter class with string values.
public SpreadValuesFilter(IEnumerable<string> stringValues)The string values to match.
Properties
Gets the date group items to match.
public IList<SpreadDateGroupItem> DateItems { get; }Gets the string values to match.
public IList<string> StringValues { get; }