CustomFilter Class

Namespace:
GemBox.Spreadsheet
Assembly:
GemBox.Spreadsheet.dll

Represents a filter that specifies one or two conditions (operators and values) and whether the two conditions are joined by 'and' or 'or'.

public sealed class CustomFilter : Filter
Inheritance:
System.Object
CustomFilter

Properties

And

Gets or sets the value indicating whether the two conditions have an "and" relationship. true indicates "and", false indicates "or" and null indicates that second condition won't be applied.

public bool? And { get; set; }
Property Value
System.Nullable<System.Boolean>

The value indicating whether the two conditions have an "and" relationship.

FilterType

Gets the Custom value.

public override FilterType FilterType { get; }
Property Value
FilterType

The Custom value.

Overrides

Operator

Gets or sets the operator used by the (first) filter condition.

public FilterOperator Operator { get; set; }
Property Value
FilterOperator

The operator used by the (first) filter condition.

Operator2

Gets or sets the operator used by the second filter condition.

public FilterOperator Operator2 { get; set; }
Property Value
FilterOperator

The operator used by the second filter condition.

Value

Gets or sets the value used by the (first) filter condition.

The value's type must be supported in Value (null and types supported in SupportsType(Type)).

public object Value { get; set; }
Property Value
System.Object

The value used by the (first) filter condition.

Exceptions
System.NotSupportedException

Value's type is not supported.

Value2

Gets or sets the value used by the second filter condition.

The value's type must be supported in Value (null and types supported in SupportsType(Type)).

public object Value2 { get; set; }
Property Value
System.Object

The value used by the second filter condition.

Exceptions
System.NotSupportedException

Value's type is not supported.

Methods

ToString()

Returns a System.String that represents this CustomFilter instance.

public override string ToString()
Returns
System.String

A System.String that represents this CustomFilter instance.

Overrides
Remarks

This method should be used primarily for debugging purposes and should be considered volatile (format of its return value might change in future versions).

Examples