aspose.cells

Class PivotFilterType

Utility class containing constants. Represents PivotTable Filter type.

Field Summary
const  NumberCAPTION_BEGINS_WITH
Indicates the "begins with" filter for field captions.
const  NumberCAPTION_BETWEEN
Indicates the "is between" filter for field captions.
const  NumberCAPTION_CONTAINS
Indicates the "contains" filter for field captions.
const  NumberCAPTION_ENDS_WITH
Indicates the "ends with" filter for field captions.
const  NumberCAPTION_EQUAL
Indicates the "equal" filter for field captions.
const  NumberCAPTION_GREATER_THAN
Indicates the "is greater than" filter for field captions.
const  NumberCAPTION_GREATER_THAN_OR_EQUAL
Indicates the "is greater than or equal to" filter for field captions.
const  NumberCAPTION_LESS_THAN
Indicates the "is less than" filter for field captions.
const  NumberCAPTION_LESS_THAN_OR_EQUAL
Indicates the "is less than or equal to" filter for field captions.
const  NumberCAPTION_NOT_BEGINS_WITH
Indicates the "does not begin with" filter for field captions.
const  NumberCAPTION_NOT_BETWEEN
Indicates the "is not between" filter for field captions.
const  NumberCAPTION_NOT_CONTAINS
Indicates the "does not contain" filter for field captions.
const  NumberCAPTION_NOT_ENDS_WITH
Indicates the "does not end with" filter for field captions.
const  NumberCAPTION_NOT_EQUAL
Indicates the "not equal" filter for field captions.
const  NumberCOUNT
Indicates the "count" filter.
const  NumberDATE_BETWEEN
Indicates the "between" filter for date values.
const  NumberDATE_EQUAL
Indicates the "equals" filter for date values.
const  NumberDATE_NEWER_THAN
Indicates the "newer than" filter for date values.
const  NumberDATE_NEWER_THAN_OR_EQUAL
Indicates the "newer than or equal to" filter for date values.
const  NumberDATE_NOT_BETWEEN
Indicates the "not between" filter for date values.
const  NumberDATE_NOT_EQUAL
Indicates the "does not equal" filter for date values.
const  NumberDATE_OLDER_THAN
Indicates the "older than" filter for date values.
const  NumberDATE_OLDER_THAN_OR_EQUAL
Indicates the "older than or equal to" filter for date values.
const  NumberLAST_MONTH
Indicates the "last month" filter for date values.
const  NumberLAST_QUARTER
Indicates the "last quarter" filter for date values.
const  NumberLAST_WEEK
Indicates the "last week" filter for date values.
const  NumberLAST_YEAR
Indicates the "last year" filter for date values.
const  NumberM_1
Indicates the "January" filter for date values.
const  NumberM_2
Indicates the "February" filter for date values.
const  NumberM_3
Indicates the "March" filter for date values.
const  NumberM_4
Indicates the "April" filter for date values.
const  NumberM_5
Indicates the "May" filter for date values.
const  NumberM_6
Indicates the "June" filter for date values.
const  NumberM_7
Indicates the "July" filter for date values.
const  NumberM_8
Indicates the "August" filter for date values.
const  NumberM_9
Indicates the "September" filter for date values.
const  NumberM_10
Indicates the "October" filter for date values.
const  NumberM_11
Indicates the "November" filter for date values.
const  NumberM_12
Indicates the "December" filter for date values.
const  NumberNEXT_MONTH
Indicates the "next month" filter for date values.
const  NumberNEXT_QUARTER
Indicates the "next quarter" for date values.
const  NumberNEXT_WEEK
Indicates the "next week" for date values.
const  NumberNEXT_YEAR
Indicates the "next year" filter for date values.
const  NumberPERCENT
Indicates the "percent" filter for numeric values.
const  NumberQ_1
Indicates the "first quarter" filter for date values.
const  NumberQ_2
Indicates the "second quarter" filter for date values.
const  NumberQ_3
Indicates the "third quarter" filter for date values.
const  NumberQ_4
Indicates the "fourth quarter" filter for date values.
const  NumberSUM
Indicates the "sum" filter for numeric values.
const  NumberTHIS_MONTH
Indicates the "this month" filter for date values.
const  NumberTHIS_QUARTER
Indicates the "this quarter" filter for date values.
const  NumberTHIS_WEEK
Indicates the "this week" filter for date values.
const  NumberTHIS_YEAR
Indicate the "this year" filter for date values.
const  NumberTODAY
Indicates the "today" filter for date values.
const  NumberTOMORROW
Indicates the "tomorrow" filter for date values.
const  NumberUNKNOWN
Indicates the PivotTable filter is unknown to the application.
const  NumberVALUE_BETWEEN
Indicates the "Value between" filter for text and numeric values.
const  NumberVALUE_EQUAL
Indicates the "value equal" filter for text and numeric values.
const  NumberVALUE_GREATER_THAN
Indicates the "value greater than" filter for text and numeric values.
const  NumberVALUE_GREATER_THAN_OR_EQUAL
Indicates the "value greater than or equal to" filter for text and numeric values.
const  NumberVALUE_LESS_THAN
Indicates the "value less than" filter for text and numeric values.
const  NumberVALUE_LESS_THAN_OR_EQUAL
Indicates the "value less than or equal to" filter for text and numeric values.
const  NumberVALUE_NOT_BETWEEN
Indicates the "value not between" filter for text and numeric values.
const  NumberVALUE_NOT_EQUAL
Indicates the "value not equal" filter for text and numeric values.
const  NumberYEAR_TO_DATE
Indicates the "year-to-date" filter for date values.
const  NumberYESTERDAY
Indicates the "yesterday" filter for date values.
 

    • 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.