Excel.PivotLabelFilter interface

Package:

excel

Configurable template for a label filter to apply to a PivotField. The condition defines what criteria need to be set in order for the filter to operate.

Remarks

[ API set: ExcelApi 1.12 ]

Properties

comparator	The comparator is the static value to which other values are compared. The type of comparison is defined by the condition. Note: A numeric string is treated as a number when being compared against other numeric strings.
condition	Specifies the condition for the filter, which defines the necessary filtering criteria.
exclusive	If true, filter excludes items that meet criteria. The default is false (filter to include items that meet criteria).
lowerBound	The lower-bound of the range for the between filter condition. Note: A numeric string is treated as a number when being compared against other numeric strings.
substring	The substring used for the beginsWith, endsWith, and contains filter conditions.
upperBound	The upper-bound of the range for the between filter condition. Note: A numeric string is treated as a number when being compared against other numeric strings.

Property Details

comparator

The comparator is the static value to which other values are compared. The type of comparison is defined by the condition. Note: A numeric string is treated as a number when being compared against other numeric strings.

comparator?: string;

Property Value

string

Remarks

[ API set: ExcelApi 1.12 ]

condition

Specifies the condition for the filter, which defines the necessary filtering criteria.

condition: Excel.LabelFilterCondition | "Unknown" | "Equals" | "BeginsWith" | "EndsWith" | "Contains" | "GreaterThan" | "GreaterThanOrEqualTo" | "LessThan" | "LessThanOrEqualTo" | "Between";

Property Value

Excel.LabelFilterCondition | "Unknown" | "Equals" | "BeginsWith" | "EndsWith" | "Contains" | "GreaterThan" | "GreaterThanOrEqualTo" | "LessThan" | "LessThanOrEqualTo" | "Between"

Remarks

[ API set: ExcelApi 1.12 ]

exclusive

If true, filter excludes items that meet criteria. The default is false (filter to include items that meet criteria).

exclusive?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.12 ]

lowerBound

The lower-bound of the range for the between filter condition. Note: A numeric string is treated as a number when being compared against other numeric strings.

lowerBound?: string;

Property Value

string

Remarks

[ API set: ExcelApi 1.12 ]

substring

The substring used for the beginsWith, endsWith, and contains filter conditions.

substring?: string;

Property Value

string

Remarks

[ API set: ExcelApi 1.12 ]

upperBound

The upper-bound of the range for the between filter condition. Note: A numeric string is treated as a number when being compared against other numeric strings.

upperBound?: string;

Property Value

string

Remarks

[ API set: ExcelApi 1.12 ]