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.

See Also:
          Aspose.Cells Documentation - the home page for the Aspose.Cellss Product Documentation.
          Aspose.Cells Support Forum - our preferred method of support.