com.aspose.cells

Class PivotFilterType

  • java.lang.Object
    • com.aspose.cells.PivotFilterType
public class PivotFilterType 
extends java.lang.Object

Utility class containing constants. Represents PivotTable Filter type.

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

    • Field Detail

      • CAPTION_BEGINS_WITH

        public static final int CAPTION_BEGINS_WITH
        Indicates the "begins with" filter for field captions.
      • CAPTION_BETWEEN

        public static final int CAPTION_BETWEEN
        Indicates the "is between" filter for field captions.
      • CAPTION_CONTAINS

        public static final int CAPTION_CONTAINS
        Indicates the "contains" filter for field captions.
      • CAPTION_ENDS_WITH

        public static final int CAPTION_ENDS_WITH
        Indicates the "ends with" filter for field captions.
      • CAPTION_EQUAL

        public static final int CAPTION_EQUAL
        Indicates the "equal" filter for field captions.
      • CAPTION_GREATER_THAN

        public static final int CAPTION_GREATER_THAN
        Indicates the "is greater than" filter for field captions.
      • CAPTION_GREATER_THAN_OR_EQUAL

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

        public static final int CAPTION_LESS_THAN
        Indicates the "is less than" filter for field captions.
      • CAPTION_LESS_THAN_OR_EQUAL

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

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

        public static final int CAPTION_NOT_BETWEEN
        Indicates the "is not between" filter for field captions.
      • CAPTION_NOT_CONTAINS

        public static final int CAPTION_NOT_CONTAINS
        Indicates the "does not contain" filter for field captions.
      • CAPTION_NOT_ENDS_WITH

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

        public static final int CAPTION_NOT_EQUAL
        Indicates the "not equal" filter for field captions.
      • COUNT

        public static final int COUNT
        Indicates the "count" filter.
      • DATE_BETWEEN

        public static final int DATE_BETWEEN
        Indicates the "between" filter for date values.
      • DATE_EQUAL

        public static final int DATE_EQUAL
        Indicates the "equals" filter for date values.
      • DATE_NEWER_THAN

        public static final int DATE_NEWER_THAN
        Indicates the "newer than" filter for date values.
      • DATE_NEWER_THAN_OR_EQUAL

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

        public static final int DATE_NOT_BETWEEN
        Indicates the "not between" filter for date values.
      • DATE_NOT_EQUAL

        public static final int DATE_NOT_EQUAL
        Indicates the "does not equal" filter for date values.
      • DATE_OLDER_THAN

        public static final int DATE_OLDER_THAN
        Indicates the "older than" filter for date values.
      • DATE_OLDER_THAN_OR_EQUAL

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

        public static final int LAST_MONTH
        Indicates the "last month" filter for date values.
      • LAST_QUARTER

        public static final int LAST_QUARTER
        Indicates the "last quarter" filter for date values.
      • LAST_WEEK

        public static final int LAST_WEEK
        Indicates the "last week" filter for date values.
      • LAST_YEAR

        public static final int LAST_YEAR
        Indicates the "last year" filter for date values.
      • M_1

        public static final int M_1
        Indicates the "January" filter for date values.
      • M_2

        public static final int M_2
        Indicates the "February" filter for date values.
      • M_3

        public static final int M_3
        Indicates the "March" filter for date values.
      • M_4

        public static final int M_4
        Indicates the "April" filter for date values.
      • M_5

        public static final int M_5
        Indicates the "May" filter for date values.
      • M_6

        public static final int M_6
        Indicates the "June" filter for date values.
      • M_7

        public static final int M_7
        Indicates the "July" filter for date values.
      • M_8

        public static final int M_8
        Indicates the "August" filter for date values.
      • M_9

        public static final int M_9
        Indicates the "September" filter for date values.
      • M_10

        public static final int M_10
        Indicates the "October" filter for date values.
      • M_11

        public static final int M_11
        Indicates the "November" filter for date values.
      • M_12

        public static final int M_12
        Indicates the "December" filter for date values.
      • NEXT_MONTH

        public static final int NEXT_MONTH
        Indicates the "next month" filter for date values.
      • NEXT_QUARTER

        public static final int NEXT_QUARTER
        Indicates the "next quarter" for date values.
      • NEXT_WEEK

        public static final int NEXT_WEEK
        Indicates the "next week" for date values.
      • NEXT_YEAR

        public static final int NEXT_YEAR
        Indicates the "next year" filter for date values.
      • PERCENT

        public static final int PERCENT
        Indicates the "percent" filter for numeric values.
      • Q_1

        public static final int Q_1
        Indicates the "first quarter" filter for date values.
      • Q_2

        public static final int Q_2
        Indicates the "second quarter" filter for date values.
      • Q_3

        public static final int Q_3
        Indicates the "third quarter" filter for date values.
      • Q_4

        public static final int Q_4
        Indicates the "fourth quarter" filter for date values.
      • SUM

        public static final int SUM
        Indicates the "sum" filter for numeric values.
      • THIS_MONTH

        public static final int THIS_MONTH
        Indicates the "this month" filter for date values.
      • THIS_QUARTER

        public static final int THIS_QUARTER
        Indicates the "this quarter" filter for date values.
      • THIS_WEEK

        public static final int THIS_WEEK
        Indicates the "this week" filter for date values.
      • THIS_YEAR

        public static final int THIS_YEAR
        Indicate the "this year" filter for date values.
      • TODAY

        public static final int TODAY
        Indicates the "today" filter for date values.
      • TOMORROW

        public static final int TOMORROW
        Indicates the "tomorrow" filter for date values.
      • UNKNOWN

        public static final int UNKNOWN
        Indicates the PivotTable filter is unknown to the application.
      • VALUE_BETWEEN

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

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

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

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

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

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

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

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

        public static final int YEAR_TO_DATE
        Indicates the "year-to-date" filter for date values.
      • YESTERDAY

        public static final int YESTERDAY
        Indicates the "yesterday" filter for date values.