Enum PivotFilterType2007
Filter type
Namespace: Syncfusion.XlsIO
Assembly: Syncfusion.XlsIO.Base.dll
Syntax
public enum PivotFilterType2007
Fields
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. |