Represents a filter which can filter data based on one or two custom conditions. 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.

Constructors

Section titled "Constructors"

CustomFilter 

new CustomFilter(a: number, b: IFilterable, c: CustomFilterCondition): CustomFilter

Returns CustomFilter

Properties

Section titled "Properties"

$t

Section titled "$t" 
$t: Type

Accessors

Section titled "Accessors"

condition1

Section titled "condition1"

Gets or sets the first condition by which to filter the cells in the data range.

 
get condition1(): CustomFilterCondition

Returns CustomFilterCondition 

set condition1(a: CustomFilterCondition): void

Parameters

Returns void

condition2

Section titled "condition2"

Gets or sets the second condition by which to filter the cells in the data range.

 
get condition2(): CustomFilterCondition

Returns CustomFilterCondition 

set condition2(a: CustomFilterCondition): void

Parameters

Returns void

conditionalOperator

Section titled "conditionalOperator"

Gets or sets the operator which defines how to logically combine [[condition1]] and [[condition2]]

 
get conditionalOperator(): ConditionalOperator

Returns ConditionalOperator 

set conditionalOperator(a: ConditionalOperator): void

Parameters

Returns void