asposecells.api

Class PivotFilterType

Utility class containing constants. Represents PivotTable Filter type.

Field Summary
const  intCAPTION_BEGINS_WITH
Indicates the "begins with" filter for field captions.
const  intCAPTION_BETWEEN
Indicates the "is between" filter for field captions.
const  intCAPTION_CONTAINS
Indicates the "contains" filter for field captions.
const  intCAPTION_ENDS_WITH
Indicates the "ends with" filter for field captions.
const  intCAPTION_EQUAL
Indicates the "equal" filter for field captions.
const  intCAPTION_GREATER_THAN
Indicates the "is greater than" filter for field captions.
const  intCAPTION_GREATER_THAN_OR_EQUAL
Indicates the "is greater than or equal to" filter for field captions.
const  intCAPTION_LESS_THAN
Indicates the "is less than" filter for field captions.
const  intCAPTION_LESS_THAN_OR_EQUAL
Indicates the "is less than or equal to" filter for field captions.
const  intCAPTION_NOT_BEGINS_WITH
Indicates the "does not begin with" filter for field captions.
const  intCAPTION_NOT_BETWEEN
Indicates the "is not between" filter for field captions.
const  intCAPTION_NOT_CONTAINS
Indicates the "does not contain" filter for field captions.
const  intCAPTION_NOT_ENDS_WITH
Indicates the "does not end with" filter for field captions.
const  intCAPTION_NOT_EQUAL
Indicates the "not equal" filter for field captions.
const  intCOUNT
Indicates the "count" filter.
const  intDATE_BETWEEN
Indicates the "between" filter for date values.
const  intDATE_EQUAL
Indicates the "equals" filter for date values.
const  intDATE_NEWER_THAN
Indicates the "newer than" filter for date values.
const  intDATE_NEWER_THAN_OR_EQUAL
Indicates the "newer than or equal to" filter for date values.
const  intDATE_NOT_BETWEEN
Indicates the "not between" filter for date values.
const  intDATE_NOT_EQUAL
Indicates the "does not equal" filter for date values.
const  intDATE_OLDER_THAN
Indicates the "older than" filter for date values.
const  intDATE_OLDER_THAN_OR_EQUAL
Indicates the "older than or equal to" filter for date values.
const  intLAST_MONTH
Indicates the "last month" filter for date values.
const  intLAST_QUARTER
Indicates the "last quarter" filter for date values.
const  intLAST_WEEK
Indicates the "last week" filter for date values.
const  intLAST_YEAR
Indicates the "last year" filter for date values.
const  intM_1
Indicates the "January" filter for date values.
const  intM_2
Indicates the "February" filter for date values.
const  intM_3
Indicates the "March" filter for date values.
const  intM_4
Indicates the "April" filter for date values.
const  intM_5
Indicates the "May" filter for date values.
const  intM_6
Indicates the "June" filter for date values.
const  intM_7
Indicates the "July" filter for date values.
const  intM_8
Indicates the "August" filter for date values.
const  intM_9
Indicates the "September" filter for date values.
const  intM_10
Indicates the "October" filter for date values.
const  intM_11
Indicates the "November" filter for date values.
const  intM_12
Indicates the "December" filter for date values.
const  intNEXT_MONTH
Indicates the "next month" filter for date values.
const  intNEXT_QUARTER
Indicates the "next quarter" for date values.
const  intNEXT_WEEK
Indicates the "next week" for date values.
const  intNEXT_YEAR
Indicates the "next year" filter for date values.
const  intPERCENT
Indicates the "percent" filter for numeric values.
const  intQ_1
Indicates the "first quarter" filter for date values.
const  intQ_2
Indicates the "second quarter" filter for date values.
const  intQ_3
Indicates the "third quarter" filter for date values.
const  intQ_4
Indicates the "fourth quarter" filter for date values.
const  intSUM
Indicates the "sum" filter for numeric values.
const  intTHIS_MONTH
Indicates the "this month" filter for date values.
const  intTHIS_QUARTER
Indicates the "this quarter" filter for date values.
const  intTHIS_WEEK
Indicates the "this week" filter for date values.
const  intTHIS_YEAR
Indicate the "this year" filter for date values.
const  intTODAY
Indicates the "today" filter for date values.
const  intTOMORROW
Indicates the "tomorrow" filter for date values.
const  intUNKNOWN
Indicates the PivotTable filter is unknown to the application.
const  intVALUE_BETWEEN
Indicates the "Value between" filter for text and numeric values.
const  intVALUE_EQUAL
Indicates the "value equal" filter for text and numeric values.
const  intVALUE_GREATER_THAN
Indicates the "value greater than" filter for text and numeric values.
const  intVALUE_GREATER_THAN_OR_EQUAL
Indicates the "value greater than or equal to" filter for text and numeric values.
const  intVALUE_LESS_THAN
Indicates the "value less than" filter for text and numeric values.
const  intVALUE_LESS_THAN_OR_EQUAL
Indicates the "value less than or equal to" filter for text and numeric values.
const  intVALUE_NOT_BETWEEN
Indicates the "value not between" filter for text and numeric values.
const  intVALUE_NOT_EQUAL
Indicates the "value not equal" filter for text and numeric values.
const  intYEAR_TO_DATE
Indicates the "year-to-date" filter for date values.
const  intYESTERDAY
Indicates the "yesterday" filter for date values.
 

    • Field Detail

      • CAPTION_BEGINS_WITH

        const int CAPTION_BEGINS_WITH
        Indicates the "begins with" filter for field captions.
      • CAPTION_BETWEEN

        const int CAPTION_BETWEEN
        Indicates the "is between" filter for field captions.
      • CAPTION_CONTAINS

        const int CAPTION_CONTAINS
        Indicates the "contains" filter for field captions.
      • CAPTION_ENDS_WITH

        const int CAPTION_ENDS_WITH
        Indicates the "ends with" filter for field captions.
      • CAPTION_EQUAL

        const int CAPTION_EQUAL
        Indicates the "equal" filter for field captions.
      • CAPTION_GREATER_THAN

        const int CAPTION_GREATER_THAN
        Indicates the "is greater than" filter for field captions.
      • CAPTION_GREATER_THAN_OR_EQUAL

        const int CAPTION_GREATER_THAN_OR_EQUAL
        Indicates the "is greater than or equal to" filter for field captions.
      • CAPTION_LESS_THAN

        const int CAPTION_LESS_THAN
        Indicates the "is less than" filter for field captions.
      • CAPTION_LESS_THAN_OR_EQUAL

        const int CAPTION_LESS_THAN_OR_EQUAL
        Indicates the "is less than or equal to" filter for field captions.
      • CAPTION_NOT_BEGINS_WITH

        const int CAPTION_NOT_BEGINS_WITH
        Indicates the "does not begin with" filter for field captions.
      • CAPTION_NOT_BETWEEN

        const int CAPTION_NOT_BETWEEN
        Indicates the "is not between" filter for field captions.
      • CAPTION_NOT_CONTAINS

        const int CAPTION_NOT_CONTAINS
        Indicates the "does not contain" filter for field captions.
      • CAPTION_NOT_ENDS_WITH

        const int CAPTION_NOT_ENDS_WITH
        Indicates the "does not end with" filter for field captions.
      • CAPTION_NOT_EQUAL

        const int CAPTION_NOT_EQUAL
        Indicates the "not equal" filter for field captions.
      • COUNT

        const int COUNT
        Indicates the "count" filter.
      • DATE_BETWEEN

        const int DATE_BETWEEN
        Indicates the "between" filter for date values.
      • DATE_EQUAL

        const int DATE_EQUAL
        Indicates the "equals" filter for date values.
      • DATE_NEWER_THAN

        const int DATE_NEWER_THAN
        Indicates the "newer than" filter for date values.
      • DATE_NEWER_THAN_OR_EQUAL

        const int DATE_NEWER_THAN_OR_EQUAL
        Indicates the "newer than or equal to" filter for date values.
      • DATE_NOT_BETWEEN

        const int DATE_NOT_BETWEEN
        Indicates the "not between" filter for date values.
      • DATE_NOT_EQUAL

        const int DATE_NOT_EQUAL
        Indicates the "does not equal" filter for date values.
      • DATE_OLDER_THAN

        const int DATE_OLDER_THAN
        Indicates the "older than" filter for date values.
      • DATE_OLDER_THAN_OR_EQUAL

        const int DATE_OLDER_THAN_OR_EQUAL
        Indicates the "older than or equal to" filter for date values.
      • LAST_MONTH

        const int LAST_MONTH
        Indicates the "last month" filter for date values.
      • LAST_QUARTER

        const int LAST_QUARTER
        Indicates the "last quarter" filter for date values.
      • LAST_WEEK

        const int LAST_WEEK
        Indicates the "last week" filter for date values.
      • LAST_YEAR

        const int LAST_YEAR
        Indicates the "last year" filter for date values.
      • M_1

        const int M_1
        Indicates the "January" filter for date values.
      • M_2

        const int M_2
        Indicates the "February" filter for date values.
      • M_3

        const int M_3
        Indicates the "March" filter for date values.
      • M_4

        const int M_4
        Indicates the "April" filter for date values.
      • M_5

        const int M_5
        Indicates the "May" filter for date values.
      • M_6

        const int M_6
        Indicates the "June" filter for date values.
      • M_7

        const int M_7
        Indicates the "July" filter for date values.
      • M_8

        const int M_8
        Indicates the "August" filter for date values.
      • M_9

        const int M_9
        Indicates the "September" filter for date values.
      • M_10

        const int M_10
        Indicates the "October" filter for date values.
      • M_11

        const int M_11
        Indicates the "November" filter for date values.
      • M_12

        const int M_12
        Indicates the "December" filter for date values.
      • NEXT_MONTH

        const int NEXT_MONTH
        Indicates the "next month" filter for date values.
      • NEXT_QUARTER

        const int NEXT_QUARTER
        Indicates the "next quarter" for date values.
      • NEXT_WEEK

        const int NEXT_WEEK
        Indicates the "next week" for date values.
      • NEXT_YEAR

        const int NEXT_YEAR
        Indicates the "next year" filter for date values.
      • PERCENT

        const int PERCENT
        Indicates the "percent" filter for numeric values.
      • Q_1

        const int Q_1
        Indicates the "first quarter" filter for date values.
      • Q_2

        const int Q_2
        Indicates the "second quarter" filter for date values.
      • Q_3

        const int Q_3
        Indicates the "third quarter" filter for date values.
      • Q_4

        const int Q_4
        Indicates the "fourth quarter" filter for date values.
      • SUM

        const int SUM
        Indicates the "sum" filter for numeric values.
      • THIS_MONTH

        const int THIS_MONTH
        Indicates the "this month" filter for date values.
      • THIS_QUARTER

        const int THIS_QUARTER
        Indicates the "this quarter" filter for date values.
      • THIS_WEEK

        const int THIS_WEEK
        Indicates the "this week" filter for date values.
      • THIS_YEAR

        const int THIS_YEAR
        Indicate the "this year" filter for date values.
      • TODAY

        const int TODAY
        Indicates the "today" filter for date values.
      • TOMORROW

        const int TOMORROW
        Indicates the "tomorrow" filter for date values.
      • UNKNOWN

        const int UNKNOWN
        Indicates the PivotTable filter is unknown to the application.
      • VALUE_BETWEEN

        const int VALUE_BETWEEN
        Indicates the "Value between" filter for text and numeric values.
      • VALUE_EQUAL

        const int VALUE_EQUAL
        Indicates the "value equal" filter for text and numeric values.
      • VALUE_GREATER_THAN

        const int VALUE_GREATER_THAN
        Indicates the "value greater than" filter for text and numeric values.
      • VALUE_GREATER_THAN_OR_EQUAL

        const int VALUE_GREATER_THAN_OR_EQUAL
        Indicates the "value greater than or equal to" filter for text and numeric values.
      • VALUE_LESS_THAN

        const int VALUE_LESS_THAN
        Indicates the "value less than" filter for text and numeric values.
      • VALUE_LESS_THAN_OR_EQUAL

        const int VALUE_LESS_THAN_OR_EQUAL
        Indicates the "value less than or equal to" filter for text and numeric values.
      • VALUE_NOT_BETWEEN

        const int VALUE_NOT_BETWEEN
        Indicates the "value not between" filter for text and numeric values.
      • VALUE_NOT_EQUAL

        const int VALUE_NOT_EQUAL
        Indicates the "value not equal" filter for text and numeric values.
      • YEAR_TO_DATE

        const int YEAR_TO_DATE
        Indicates the "year-to-date" filter for date values.
      • YESTERDAY

        const int YESTERDAY
        Indicates the "yesterday" filter for date values.