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.

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