Represents a single comparison criterion for a custom filter.
The FilterValue may be an empty string, which is a valid filter value in Excel. An empty string matches cells that contain exactly the empty string.
Wildcards
(any sequence) and?(single char) can be used in FilterValue when the comparison operator is EqualsTo or NotEqualsTo. To match a literal,?, or, escape it with a tilde:*,~?,~~.
Definition
Namespace:Telerik.Documents.SpreadsheetStreaming
Assembly:Telerik.Documents.SpreadsheetStreaming.dll
Syntax:
public class SpreadCustomFilterCriteriaInheritance: objectSpreadCustomFilterCriteria
Constructors
Initializes a new instance of the SpreadCustomFilterCriteria class.
public SpreadCustomFilterCriteria(SpreadComparisonOperator comparisonOperator, string filterValue)The comparison operator.
filterValuestringThe value to compare against. May be empty but not null.
Exceptions: ArgumentNullExceptionThrown when filterValue is null.
Properties
Gets the comparison operator.
public SpreadComparisonOperator ComparisonOperator { get; }Gets the value to compare against.
public string FilterValue { get; }