Click or drag to resize

DynamicFilterValues Enumeration

Dynamic Filter

Namespace: DocumentFormat.OpenXml.Spreadsheet
Assembly: DocumentFormat.OpenXml (in DocumentFormat.OpenXml.dll) Version: 2.20.0+Branch.release-v2.20.0.Sha.a873d3fbff9bffe179fea62486da950adf5be65d.a873d3fbff9bffe179fea62486da950adf5be65d
Syntax
public enum DynamicFilterValues
Members
Member nameValueDescription
Null0 Null.

When the item is serialized out as xml, its value is "null".

AboveAverage1 Above Average.

When the item is serialized out as xml, its value is "aboveAverage".

BelowAverage2 Below Average.

When the item is serialized out as xml, its value is "belowAverage".

Tomorrow3 Tomorrow.

When the item is serialized out as xml, its value is "tomorrow".

Today4 Today.

When the item is serialized out as xml, its value is "today".

Yesterday5 Yesterday.

When the item is serialized out as xml, its value is "yesterday".

NextWeek6 Next Week.

When the item is serialized out as xml, its value is "nextWeek".

ThisWeek7 This Week.

When the item is serialized out as xml, its value is "thisWeek".

LastWeek8 Last Week.

When the item is serialized out as xml, its value is "lastWeek".

NextMonth9 Next Month.

When the item is serialized out as xml, its value is "nextMonth".

ThisMonth10 This Month.

When the item is serialized out as xml, its value is "thisMonth".

LastMonth11 Last Month.

When the item is serialized out as xml, its value is "lastMonth".

NextQuarter12 Next Quarter.

When the item is serialized out as xml, its value is "nextQuarter".

ThisQuarter13 This Quarter.

When the item is serialized out as xml, its value is "thisQuarter".

LastQuarter14 Last Quarter.

When the item is serialized out as xml, its value is "lastQuarter".

NextYear15 Next Year.

When the item is serialized out as xml, its value is "nextYear".

ThisYear16 This Year.

When the item is serialized out as xml, its value is "thisYear".

LastYear17 Last Year.

When the item is serialized out as xml, its value is "lastYear".

YearToDate18 Year To Date.

When the item is serialized out as xml, its value is "yearToDate".

Quarter119 1st Quarter.

When the item is serialized out as xml, its value is "Q1".

Quarter220 2nd Quarter.

When the item is serialized out as xml, its value is "Q2".

Quarter321 3rd Quarter.

When the item is serialized out as xml, its value is "Q3".

Quarter422 4th Quarter.

When the item is serialized out as xml, its value is "Q4".

January23 1st Month.

When the item is serialized out as xml, its value is "M1".

February24 2nd Month.

When the item is serialized out as xml, its value is "M2".

March25 3rd Month.

When the item is serialized out as xml, its value is "M3".

April26 4th Month.

When the item is serialized out as xml, its value is "M4".

May27 5th Month.

When the item is serialized out as xml, its value is "M5".

June28 6th Month.

When the item is serialized out as xml, its value is "M6".

July29 7th Month.

When the item is serialized out as xml, its value is "M7".

August30 8th Month.

When the item is serialized out as xml, its value is "M8".

September31 9th Month.

When the item is serialized out as xml, its value is "M9".

October32 10th Month.

When the item is serialized out as xml, its value is "M10".

November33 11th Month.

When the item is serialized out as xml, its value is "M11".

December34 12th Month.

When the item is serialized out as xml, its value is "M12".

See Also