Gets the average that was computed the last time the filter was applied or 0 if any errors or all non-numeric values were found when applying the filter. Syntax
Gets or sets the value indicating whether to filter in values below or above the average of the data range. Syntax Property Value AboveAverage to show cells above the average of the data range; BelowAverage to show cells below the average. Exceptions Exception Description System.ComponentModel.InvalidEnumArgumentE...
Represents the various calendar types available for the FixedValuesFilter Syntax Members Member Description Gregorian The Gregorian calendar should be used. GregorianArabic The Arabic version of the Gregorian calendar should be used. GregorianMeFrench The Middle East French version of the Gregorian calendar should...
Represents the various logical operators used to combine the conditions of the CustomFilter. Syntax Members Member Description And Filter in values where only CustomFilter.Condition1 and CustomFilter.Condition2 pass. Or Filter in values where either CustomFilter.Condition1 or CustomFilter.Condition2 (or both) pass...
Represents a filter which can filter data based on one or two custom conditions. Syntax Remarks This filter type allows you to specify one or two filter conditions which have a comparison operator and value. These two filter conditions can be combined with a logical and or a logical or operation.
A filter condition used in a CustomFilter. Syntax Remarks The CustomFilterCondition contains a comparison operator and a value. The value of each cell in the data range is compared against the condition value using the comparison operator.
Public Constructors Public Properties Public Methods
Public Methods
Public Properties
Gets the operator which describes how the cell values should be compared against Value. Syntax