DynamicFilterValues enumeration
Office 2013 and later
Dynamic Filter
Namespace: DocumentFormat.OpenXml.Spreadsheet
Assembly: DocumentFormat.OpenXml (in DocumentFormat.OpenXml.dll)
| Member name | Description | |
|---|---|---|
| Null | Null. When the item is serialized out as xml, its value is "null". | |
| AboveAverage | Above Average. When the item is serialized out as xml, its value is "aboveAverage". | |
| BelowAverage | Below Average. When the item is serialized out as xml, its value is "belowAverage". | |
| Tomorrow | Tomorrow. When the item is serialized out as xml, its value is "tomorrow". | |
| Today | Today. When the item is serialized out as xml, its value is "today". | |
| Yesterday | Yesterday. When the item is serialized out as xml, its value is "yesterday". | |
| NextWeek | Next Week. When the item is serialized out as xml, its value is "nextWeek". | |
| ThisWeek | This Week. When the item is serialized out as xml, its value is "thisWeek". | |
| LastWeek | Last Week. When the item is serialized out as xml, its value is "lastWeek". | |
| NextMonth | Next Month. When the item is serialized out as xml, its value is "nextMonth". | |
| ThisMonth | This Month. When the item is serialized out as xml, its value is "thisMonth". | |
| LastMonth | Last Month. When the item is serialized out as xml, its value is "lastMonth". | |
| NextQuarter | Next Quarter. When the item is serialized out as xml, its value is "nextQuarter". | |
| ThisQuarter | This Quarter. When the item is serialized out as xml, its value is "thisQuarter". | |
| LastQuarter | Last Quarter. When the item is serialized out as xml, its value is "lastQuarter". | |
| NextYear | Next Year. When the item is serialized out as xml, its value is "nextYear". | |
| ThisYear | This Year. When the item is serialized out as xml, its value is "thisYear". | |
| LastYear | Last Year. When the item is serialized out as xml, its value is "lastYear". | |
| YearToDate | Year To Date. When the item is serialized out as xml, its value is "yearToDate". | |
| Quarter1 | 1st Quarter. When the item is serialized out as xml, its value is "Q1". | |
| Quarter2 | 2nd Quarter. When the item is serialized out as xml, its value is "Q2". | |
| Quarter3 | 3rd Quarter. When the item is serialized out as xml, its value is "Q3". | |
| Quarter4 | 4th Quarter. When the item is serialized out as xml, its value is "Q4". | |
| January | 1st Month. When the item is serialized out as xml, its value is "M1". | |
| February | 2nd Month. When the item is serialized out as xml, its value is "M2". | |
| March | 3rd Month. When the item is serialized out as xml, its value is "M3". | |
| April | 4th Month. When the item is serialized out as xml, its value is "M4". | |
| May | 5th Month. When the item is serialized out as xml, its value is "M5". | |
| June | 6th Month. When the item is serialized out as xml, its value is "M6". | |
| July | 7th Month. When the item is serialized out as xml, its value is "M7". | |
| August | 8th Month. When the item is serialized out as xml, its value is "M8". | |
| September | 9th Month. When the item is serialized out as xml, its value is "M9". | |
| October | 10th Month. When the item is serialized out as xml, its value is "M10". | |
| November | 11th Month. When the item is serialized out as xml, its value is "M11". | |
| December | 12th Month. When the item is serialized out as xml, its value is "M12". |
Show: