Gets or sets the first condition by which to filter the cells in the data range. Syntax Exceptions Exception Description System.ArgumentNullException The value assigned is null. Remarks The first filter condition is required. Setting Condition1 to null will cause an exception to be thrown. When both Condition1 and...
Gets or sets the second condition by which to filter the cells in the data range. Syntax Remarks The second filter condition is optional. A value of null indicates that only Condition1 should be used to filter the data. When both Condition1 and Condition2 are set, the ConditionalOperator is used to determine how t...
Gets or sets the operator which defines how to logically combine Condition1 and Condition2 Syntax Property Value And to require both conditions to pass for the data to be filtered in. Or to allow data to be filtered in when one or both conditions are met. Exceptions Exception Description System.ComponentModel.Inva...
Represents a filter which can filter dates in a specific period. Syntax Remarks This filter allows dates to be filtered in if they are in a specific month or quarter of any year.
Represents the various date range types which can be filtered by the DatePeriodFilter. Syntax Members Member Description Month Filter in dates in a specific month of any year. Quarter Filter in dates in a specific quarter of any year.
Public Properties
Public Properties
Gets or sets the type of date period to filter in. Syntax Property Value Month to filter in dates in a specific month of any year; Quarter to filter in dates in a specific quarter of any year. Exceptions Exception Description System.ComponentModel.InvalidEnumArgumentException The value assigned is not defined in t...
Gets or sets the 1-based value of the month or quarter to filter in. Syntax Property Value The 1-based value of the month or quarter to filter in. Exceptions Exception Description System.ArgumentException Type is Quarter and the value assigned is less than 1 or greater than 4 or Type is Month and the value assigne...
Abstract base class for filters which filter dates based on whether they are within a specified range of dates or not. Syntax