Enum PivotFilterType2007
Filter type
Namespace: Syncfusion.XlsIO
Assembly: Syncfusion.XlsIO.Base.dll
Syntax
public enum PivotFilterType2007Fields
| Name | Description |
|---|---|
| captionBeginsWith | Indicates the "caption begins with" filter for text and numeric values |
| captionBetween | Indicates the "caption between" filter for text and numeric values |
| captionContains | Indicates the "caption contains" filter for text and numeric values |
| captionEndsWith | Indicates the "caption ends with" filter for text and numeric values |
| captionEqual | Indicates the "caption equal" filter for field captions. |
| captionGreaterThan | Indicates the "caption greater than" filter for field captions. |
| captionGreaterThanOrEqual | Indicates the "caption greater than or equal to" filter for field captions. |
| captionLessThan | Indicates the "caption less than" filter for field captions. |
| captionLessThanOrEqual | Indicates the "caption less than or equal" filter for field captions. |
| captionNotBeginsWith | Indicates the "caption not begins with" filter for field captions. |
| captionNotBetween | Indicates the "caption not between" filter for field captions. |
| captionNotContains | Indicates the "caption not contains" filter for field captions. |
| captionNotEndsWith | Indicates the "caption not ends with" filter for field captions. |
| captionNotEqual | Indicates the "Caption not equal" filter for field captions. |
| count | Indicates the "count" filter. |
| dateBetween | Indicates the "dateBetween" filter. |
| dateEqual | |
| dateNewerThan | |
| dateNewerThanOrEqual | Indicates the "dateNewerThanOrEqual" filter. |
| dateNotBetween | Indicates the "dateNotBetween" filter. |
| dateNotEqual | Indicates the "dateNotEqual" filter. |
| dateOlderThan | Indicates the "dateOlderThan" filter. |
| dateOlderThanOrEqual | Indicates the "dateOlderThanOrEqual" filter. |
| lastMonth | Indicates the "lastMonth" filter. |
| lastQuarter | Indicates the "lastQuarter" filter. |
| lastWeek | Indicates the "lastWeek" filter. |
| lastYear | Indicates the "lastYear" filter. |
| M1 | Indicates the "M1" filter. |
| M10 | Indicates the "M10" filter. |
| M11 | Indicates the "M11" filter. |
| M12 | Indicates the "M12" filter. |
| M2 | Indicates the "M2" filter. |
| M3 | Indicates the "M3" filter. |
| M4 | Indicates the "M4" filter. |
| M5 | Indicates the "M5" filter. |
| M6 | Indicates the "M6" filter. |
| M7 | Indicates the "M7" filter. |
| M8 | Indicates the "M8" filter. |
| M9 | Indicates the "M9" filter. |
| nextMonth | Indicates the "nextMonth" filter. |
| nextQuarter | Indicates the "nextQuarter" filter. |
| nextYear | Indicates the "nextYear" filter. |
| nexWeek | Indicates the "nextWeek" filter. |
| percent | Indicates the "percent" filter. |
| Q1 | Indicates the "Q1" filter. |
| Q2 | Indicates the "Q2" filter. |
| Q3 | Indicates the "Q3" filter. |
| Q4 | Indicates the "Q4" filter. |
| sum | Indicates the "sum" filter. |
| thisMonth | Indicates the "thisMonth" filter. |
| thisQuarter | Indicates the "thisQuarter" filter. |
| thisWeek | Indicates the "thisWeek" filter. |
| thisYear | Indicates the "thisYear" filter. |
| today | Indicates the "today" filter. |
| tomorrow | Indicates the "tomorrow" filter. |
| unknown | Indicates the "unknown" filter. |
| valueBetween | Indicates the "value between" filter for text and numeric values |
| valueEqual | Indicates the "value equal" filter for text and numeric values |
| valueGreaterThan | Indicates the "value Greater than " filter for text and numeric values |
| valueGreaterThanOrEqual | Indicates the "value greater than or equal to" filter for text and numeric values |
| valueLessThan | Indicates the "value less than " filter for text and numeric values |
| valueLessThanOrEqual | Indicates the "value less than or equal to" filter for text and numeric values |
| valueNotBetween | Indicates the "value not between" filter for text and numeric values. |
| valueNotEqual | Indicates the "value not equal" filter for text and numeric values. |
| yearToDate | |
| yesterday | Indicates the "yesterday" filter. |