Aspose::Cells::Pivot::PivotFilterType enum
Contents
[
Hide
]PivotFilterType enum
Represents PivotTable Filter type.
enum class 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
- Library Aspose.Cells for C++