ClassSpreadValuesFilter
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
SpreadValuesFilter(IEnumerable<SpreadDateGroupItem>)
Initializes a new instance of the SpreadValuesFilter class with date group items.
Declaration
public SpreadValuesFilter(IEnumerable<SpreadDateGroupItem> dateItems)Parameters
dateItems
IEnumerable<SpreadDateGroupItem>
The date group items to match.
SpreadValuesFilter(IEnumerable<string>)
Initializes a new instance of the SpreadValuesFilter class with string values.
Declaration
public SpreadValuesFilter(IEnumerable<string> stringValues)Parameters
stringValues
The string values to match.
SpreadValuesFilter(IEnumerable<string>, IEnumerable<SpreadDateGroupItem>, bool)
Initializes a new instance of the SpreadValuesFilter class.
Declaration
public SpreadValuesFilter(IEnumerable<string> stringValues, IEnumerable<SpreadDateGroupItem> dateItems, bool blank)Parameters
stringValues
The string values to match. Can be null.
dateItems
IEnumerable<SpreadDateGroupItem>
The date group items to match. Can be null.
blank
Whether to include blank cells.
Exceptions
Thrown when any element of stringValues is null,
or when any element of dateItems is null.
SpreadValuesFilter(IEnumerable<string>, bool)
Initializes a new instance of the SpreadValuesFilter class with string values and blank option.
Declaration
public SpreadValuesFilter(IEnumerable<string> stringValues, bool blank)Parameters
stringValues
The string values to match.
blank
Whether to include blank cells.
Properties
Blank
Gets a value indicating whether to include blank cells.
DateItems
Gets the date group items to match.
Declaration
public IList<SpreadDateGroupItem> DateItems { get; }Property Value
StringValues
Gets the string values to match.