DynamicFilterValues Enumeration

Dynamic Filter

Namespace:  DocumentFormat.OpenXml.Spreadsheet
Assembly:  DocumentFormat.OpenXml (in DocumentFormat.OpenXml.dll)

Syntax

'Declaration
Public Enumeration DynamicFilterValues
'Usage
Dim instance As DynamicFilterValues
public enum DynamicFilterValues

Members

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".

See Also

Reference

DocumentFormat.OpenXml.Spreadsheet Namespace