aspose.cells

Field Detail

• CAPTION_BEGINS_WITH

  const Number CAPTION_BEGINS_WITH

  Indicates the "begins with" filter for field captions.

• CAPTION_BETWEEN

  const Number CAPTION_BETWEEN

  Indicates the "is between" filter for field captions.

• CAPTION_CONTAINS

  const Number CAPTION_CONTAINS

  Indicates the "contains" filter for field captions.

• CAPTION_ENDS_WITH

  const Number CAPTION_ENDS_WITH

  Indicates the "ends with" filter for field captions.

• CAPTION_EQUAL

  const Number CAPTION_EQUAL

  Indicates the "equal" filter for field captions.

• CAPTION_GREATER_THAN

  const Number CAPTION_GREATER_THAN

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

• CAPTION_GREATER_THAN_OR_EQUAL

  const Number CAPTION_GREATER_THAN_OR_EQUAL

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

• CAPTION_LESS_THAN

  const Number CAPTION_LESS_THAN

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

• CAPTION_LESS_THAN_OR_EQUAL

  const Number CAPTION_LESS_THAN_OR_EQUAL

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

• CAPTION_NOT_BEGINS_WITH

  const Number CAPTION_NOT_BEGINS_WITH

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

• CAPTION_NOT_BETWEEN

  const Number CAPTION_NOT_BETWEEN

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

• CAPTION_NOT_CONTAINS

  const Number CAPTION_NOT_CONTAINS

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

• CAPTION_NOT_ENDS_WITH

  const Number CAPTION_NOT_ENDS_WITH

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

• CAPTION_NOT_EQUAL

  const Number CAPTION_NOT_EQUAL

  Indicates the "not equal" filter for field captions.

• COUNT

  const Number COUNT

  Indicates the "count" filter.

• DATE_BETWEEN

  const Number DATE_BETWEEN

  Indicates the "between" filter for date values.

• DATE_EQUAL

  const Number DATE_EQUAL

  Indicates the "equals" filter for date values.

• DATE_NEWER_THAN

  const Number DATE_NEWER_THAN

  Indicates the "newer than" filter for date values.

• DATE_NEWER_THAN_OR_EQUAL

  const Number DATE_NEWER_THAN_OR_EQUAL

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

• DATE_NOT_BETWEEN

  const Number DATE_NOT_BETWEEN

  Indicates the "not between" filter for date values.

• DATE_NOT_EQUAL

  const Number DATE_NOT_EQUAL

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

• DATE_OLDER_THAN

  const Number DATE_OLDER_THAN

  Indicates the "older than" filter for date values.

• DATE_OLDER_THAN_OR_EQUAL

  const Number DATE_OLDER_THAN_OR_EQUAL

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

• LAST_MONTH

  const Number LAST_MONTH

  Indicates the "last month" filter for date values.

• LAST_QUARTER

  const Number LAST_QUARTER

  Indicates the "last quarter" filter for date values.

• LAST_WEEK

  const Number LAST_WEEK

  Indicates the "last week" filter for date values.

• LAST_YEAR

  const Number LAST_YEAR

  Indicates the "last year" filter for date values.

• M_1

  const Number M_1

  Indicates the "January" filter for date values.

• M_2

  const Number M_2

  Indicates the "February" filter for date values.

• M_3

  const Number M_3

  Indicates the "March" filter for date values.

• M_4

  const Number M_4

  Indicates the "April" filter for date values.

• M_5

  const Number M_5

  Indicates the "May" filter for date values.

• M_6

  const Number M_6

  Indicates the "June" filter for date values.

• M_7

  const Number M_7

  Indicates the "July" filter for date values.

• M_8

  const Number M_8

  Indicates the "August" filter for date values.

• M_9

  const Number M_9

  Indicates the "September" filter for date values.

• M_10

  const Number M_10

  Indicates the "October" filter for date values.

• M_11

  const Number M_11

  Indicates the "November" filter for date values.

• M_12

  const Number M_12

  Indicates the "December" filter for date values.

• NEXT_MONTH

  const Number NEXT_MONTH

  Indicates the "next month" filter for date values.

• NEXT_QUARTER

  const Number NEXT_QUARTER

  Indicates the "next quarter" for date values.

• NEXT_WEEK

  const Number NEXT_WEEK

  Indicates the "next week" for date values.

• NEXT_YEAR

  const Number NEXT_YEAR

  Indicates the "next year" filter for date values.

• PERCENT

  const Number PERCENT

  Indicates the "percent" filter for numeric values.

• Q_1

  const Number Q_1

  Indicates the "first quarter" filter for date values.

• Q_2

  const Number Q_2

  Indicates the "second quarter" filter for date values.

• Q_3

  const Number Q_3

  Indicates the "third quarter" filter for date values.

• Q_4

  const Number Q_4

  Indicates the "fourth quarter" filter for date values.

• SUM

  const Number SUM

  Indicates the "sum" filter for numeric values.

• THIS_MONTH

  const Number THIS_MONTH

  Indicates the "this month" filter for date values.

• THIS_QUARTER

  const Number THIS_QUARTER

  Indicates the "this quarter" filter for date values.

• THIS_WEEK

  const Number THIS_WEEK

  Indicates the "this week" filter for date values.

• THIS_YEAR

  const Number THIS_YEAR

  Indicate the "this year" filter for date values.

• TODAY

  const Number TODAY

  Indicates the "today" filter for date values.

• TOMORROW

  const Number TOMORROW

  Indicates the "tomorrow" filter for date values.

• UNKNOWN

  const Number UNKNOWN

  Indicates the PivotTable filter is unknown to the application.

• VALUE_BETWEEN

  const Number VALUE_BETWEEN

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

• VALUE_EQUAL

  const Number VALUE_EQUAL

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

• VALUE_GREATER_THAN

  const Number VALUE_GREATER_THAN

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

• VALUE_GREATER_THAN_OR_EQUAL

  const Number VALUE_GREATER_THAN_OR_EQUAL

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

• VALUE_LESS_THAN

  const Number VALUE_LESS_THAN

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

• VALUE_LESS_THAN_OR_EQUAL

  const Number VALUE_LESS_THAN_OR_EQUAL

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

• VALUE_NOT_BETWEEN

  const Number VALUE_NOT_BETWEEN

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

• VALUE_NOT_EQUAL

  const Number VALUE_NOT_EQUAL

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

• YEAR_TO_DATE

  const Number YEAR_TO_DATE

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

• YESTERDAY

  const Number YESTERDAY

  Indicates the "yesterday" filter for date values.