PivotFilterType
PivotFilterType enumeration
Represents PivotTable Filter type.
public enum PivotFilterType
Values
Name | Value | Description |
---|---|---|
CaptionBeginsWith | 0 |
Indicates the “begins with” filter for field captions. |
CaptionBetween | 1 |
Indicates the “is between” filter for field captions. |
CaptionContains | 2 |
Indicates the “contains” filter for field captions. |
CaptionEndsWith | 3 |
Indicates the “ends with” filter for field captions. |
CaptionEqual | 4 |
Indicates the “equal” filter for field captions. |
CaptionGreaterThan | 5 |
Indicates the “is greater than” filter for field captions. |
CaptionGreaterThanOrEqual | 6 |
Indicates the “is greater than or equal to” filter for field captions. |
CaptionLessThan | 7 |
Indicates the “is less than” filter for field captions. |
CaptionLessThanOrEqual | 8 |
Indicates the “is less than or equal to” filter for field captions. |
CaptionNotBeginsWith | 9 |
Indicates the “does not begin with” filter for field captions. |
CaptionNotBetween | 10 |
Indicates the “is not between” filter for field captions. |
CaptionNotContains | 11 |
Indicates the “does not contain” filter for field captions. |
CaptionNotEndsWith | 12 |
Indicates the “does not end with” filter for field captions. |
CaptionNotEqual | 13 |
Indicates the “not equal” filter for field captions. |
Count | 14 |
Indicates the “count” filter. |
DateBetween | 15 |
Indicates the “between” filter for date values. |
DateEqual | 16 |
Indicates the “equals” filter for date values. |
DateNewerThan | 17 |
Indicates the “newer than” filter for date values. |
DateNewerThanOrEqual | 18 |
Indicates the “newer than or equal to” filter for date values. |
DateNotBetween | 19 |
Indicates the “not between” filter for date values. |
DateNotEqual | 20 |
Indicates the “does not equal” filter for date values. |
DateOlderThan | 21 |
Indicates the “older than” filter for date values. |
DateOlderThanOrEqual | 22 |
Indicates the “older than or equal to” filter for date values. |
LastMonth | 23 |
Indicates the “last month” filter for date values. |
LastQuarter | 24 |
Indicates the “last quarter” filter for date values. |
LastWeek | 25 |
Indicates the “last week” filter for date values. |
LastYear | 26 |
Indicates the “last year” filter for date values. |
M1 | 27 |
Indicates the “January” filter for date values. |
M2 | 28 |
Indicates the “February” filter for date values. |
M3 | 29 |
Indicates the “March” filter for date values. |
M4 | 30 |
Indicates the “April” filter for date values. |
M5 | 31 |
Indicates the “May” filter for date values. |
M6 | 32 |
Indicates the “June” filter for date values. |
M7 | 33 |
Indicates the “July” filter for date values. |
M8 | 34 |
Indicates the “August” filter for date values. |
M9 | 35 |
Indicates the “September” filter for date values. |
M10 | 36 |
Indicates the “October” filter for date values. |
M11 | 37 |
Indicates the “November” filter for date values. |
M12 | 38 |
Indicates the “December” filter for date values. |
NextMonth | 39 |
Indicates the “next month” filter for date values. |
NextQuarter | 40 |
Indicates the “next quarter” for date values. |
NextWeek | 41 |
Indicates the “next week” for date values. |
NextYear | 42 |
Indicates the “next year” filter for date values. |
Percent | 43 |
Indicates the “percent” filter for numeric values. |
Q1 | 44 |
Indicates the “first quarter” filter for date values. |
Q2 | 45 |
Indicates the “second quarter” filter for date values. |
Q3 | 46 |
Indicates the “third quarter” filter for date values. |
Q4 | 47 |
Indicates the “fourth quarter” filter for date values. |
Sum | 48 |
Indicates the “sum” filter for numeric values. |
ThisMonth | 49 |
Indicates the “this month” filter for date values. |
ThisQuarter | 50 |
Indicates the “this quarter” filter for date values. |
ThisWeek | 51 |
Indicates the “this week” filter for date values. |
ThisYear | 52 |
Indicate the “this year” filter for date values. |
Today | 53 |
Indicates the “today” filter for date values. |
Tomorrow | 54 |
Indicates the “tomorrow” filter for date values. |
Unknown | 55 |
Indicates the PivotTable filter is unknown to the application. |
ValueBetween | 56 |
Indicates the “Value between” filter for text and numeric values. |
ValueEqual | 57 |
Indicates the “value equal” filter for text and numeric values. |
ValueGreaterThan | 58 |
Indicates the “value greater than” filter for text and numeric values. |
ValueGreaterThanOrEqual | 59 |
Indicates the “value greater than or equal to” filter for text and numeric values. |
ValueLessThan | 60 |
Indicates the “value less than” filter for text and numeric values. |
ValueLessThanOrEqual | 61 |
Indicates the “value less than or equal to” filter for text and numeric values. |
ValueNotBetween | 62 |
Indicates the “value not between” filter for text and numeric values. |
ValueNotEqual | 63 |
Indicates the “value not equal” filter for text and numeric values. |
YearToDate | 64 |
Indicates the “year-to-date” filter for date values. |
Yesterday | 65 |
Indicates the “yesterday” filter for date values. |
See Also
- namespace Aspose.Cells.Pivot
- assembly Aspose.Cells