aspose.cells
Class PivotFilterType

const Number CAPTION_BEGINS_WITH

Indicates the "begins with" filter for field captions.

const Number CAPTION_BETWEEN

Indicates the "is between" filter for field captions.

const Number CAPTION_CONTAINS

Indicates the "contains" filter for field captions.

const Number CAPTION_ENDS_WITH

Indicates the "ends with" filter for field captions.

const Number CAPTION_EQUAL

Indicates the "equal" filter for field captions.

const Number CAPTION_GREATER_THAN

Indicates the "is greater than" filter for field captions.

const Number CAPTION_GREATER_THAN_OR_EQUAL

Indicates the "is greater than or equal to" filter for field captions.

const Number CAPTION_LESS_THAN

Indicates the "is less than" filter for field captions.

const Number CAPTION_LESS_THAN_OR_EQUAL

Indicates the "is less than or equal to" filter for field captions.

const Number CAPTION_NOT_BEGINS_WITH

Indicates the "does not begin with" filter for field captions.

const Number CAPTION_NOT_BETWEEN

Indicates the "is not between" filter for field captions.

const Number CAPTION_NOT_CONTAINS

Indicates the "does not contain" filter for field captions.

const Number CAPTION_NOT_ENDS_WITH

Indicates the "does not end with" filter for field captions.

const Number CAPTION_NOT_EQUAL

Indicates the "not equal" filter for field captions.

const Number COUNT

Indicates the "count" filter.

const Number DATE_BETWEEN

Indicates the "between" filter for date values.

const Number DATE_EQUAL

Indicates the "equals" filter for date values.

const Number DATE_NEWER_THAN

Indicates the "newer than" filter for date values.

const Number DATE_NEWER_THAN_OR_EQUAL

Indicates the "newer than or equal to" filter for date values.

const Number DATE_NOT_BETWEEN

Indicates the "not between" filter for date values.

const Number DATE_NOT_EQUAL

Indicates the "does not equal" filter for date values.

const Number DATE_OLDER_THAN

Indicates the "older than" filter for date values.

const Number DATE_OLDER_THAN_OR_EQUAL

Indicates the "older than or equal to" filter for date values.

const Number LAST_MONTH

Indicates the "last month" filter for date values.

const Number LAST_QUARTER

Indicates the "last quarter" filter for date values.

const Number LAST_WEEK

Indicates the "last week" filter for date values.

const Number LAST_YEAR

Indicates the "last year" filter for date values.

const Number M_1

Indicates the "January" filter for date values.

const Number M_2

Indicates the "February" filter for date values.

const Number M_3

Indicates the "March" filter for date values.

const Number M_4

Indicates the "April" filter for date values.

const Number M_5

Indicates the "May" filter for date values.

const Number M_6

Indicates the "June" filter for date values.

const Number M_7

Indicates the "July" filter for date values.

const Number M_8

Indicates the "August" filter for date values.

const Number M_9

Indicates the "September" filter for date values.

const Number M_10

Indicates the "October" filter for date values.

const Number M_11

Indicates the "November" filter for date values.

const Number M_12

Indicates the "December" filter for date values.

const Number NEXT_MONTH

Indicates the "next month" filter for date values.

const Number NEXT_QUARTER

Indicates the "next quarter" for date values.

const Number NEXT_WEEK

Indicates the "next week" for date values.

const Number NEXT_YEAR

Indicates the "next year" filter for date values.

const Number PERCENT

Indicates the "percent" filter for numeric values.

const Number Q_1

Indicates the "first quarter" filter for date values.

const Number Q_2

Indicates the "second quarter" filter for date values.

const Number Q_3

Indicates the "third quarter" filter for date values.

const Number Q_4

Indicates the "fourth quarter" filter for date values.

const Number SUM

Indicates the "sum" filter for numeric values.

const Number THIS_MONTH

Indicates the "this month" filter for date values.

const Number THIS_QUARTER

Indicates the "this quarter" filter for date values.

const Number THIS_WEEK

Indicates the "this week" filter for date values.

const Number THIS_YEAR

Indicate the "this year" filter for date values.

const Number TODAY

Indicates the "today" filter for date values.

const Number TOMORROW

Indicates the "tomorrow" filter for date values.

const Number UNKNOWN

Indicates the PivotTable filter is unknown to the application.

const Number VALUE_BETWEEN

Indicates the "Value between" filter for text and numeric values.

const Number VALUE_EQUAL

Indicates the "value equal" filter for text and numeric values.

const Number VALUE_GREATER_THAN

Indicates the "value greater than" filter for text and numeric values.

const Number VALUE_GREATER_THAN_OR_EQUAL

Indicates the "value greater than or equal to" filter for text and numeric values.

const Number VALUE_LESS_THAN

Indicates the "value less than" filter for text and numeric values.

const Number VALUE_LESS_THAN_OR_EQUAL

Indicates the "value less than or equal to" filter for text and numeric values.

const Number VALUE_NOT_BETWEEN

Indicates the "value not between" filter for text and numeric values.

const Number VALUE_NOT_EQUAL

Indicates the "value not equal" filter for text and numeric values.

const Number YEAR_TO_DATE

Indicates the "year-to-date" filter for date values.

const Number YESTERDAY

Indicates the "yesterday" filter for date values.