SpreadValuesFilter
Represents a value-based filter that shows only rows matching specific string values, date groups, or blank cells.
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:Thrown 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; }