Enum eDynamicFilterType
Dynamic filter types. A dynamic filter returns a result set which might vary due to a change in the data itself.
Namespace: OfficeOpenXml.Filter
Assembly: EPPlus.dll
Syntax
public enum eDynamicFilterType
Fields
Name | Description |
---|---|
AboveAverage | Shows values that are above average. |
BelowAverage | Shows values that are below average. |
LastMonth | Shows last month's dates. |
LastQuarter | Shows last calendar quarter's dates. |
LastWeek | Shows last week's dates, using Sunday as the first weekday. |
LastYear | Shows last year's dates. |
M1 | Shows the dates that are in January, regardless of year. |
M10 | Shows the dates that are in October, regardless of year. |
M11 | Shows the dates that are in November, regardless of year. |
M12 | Shows the dates that are in December, regardless of year. |
M2 | Shows the dates that are in February, regardless of year. |
M3 | Shows the dates that are in March, regardless of year. |
M4 | Shows the dates that are in April, regardless of year. |
M5 | Shows the dates that are in May, regardless of year. |
M6 | Shows the dates that are in June, regardless of year. |
M7 | Shows the dates that are in July, regardless of year. |
M8 | Shows the dates that are in August, regardless of year. |
M9 | Shows the dates that are in September, regardless of |
NextMonth | Shows next month's dates. |
NextQuarter | Shows next calendar quarter's dates. |
NextWeek | Shows next week's dates, using Sunday as the firstweekday. |
NextYear | Shows next year's dates. |
Null | No filter |
Q1 | Shows the dates that are in the 1st calendar quarter, regardless of year. |
Q2 | Shows the dates that are in the 2nd calendar quarter, regardless of year. |
Q3 | Shows the dates that are in the 3rd calendar quarter, regardless of year. |
Q4 | Shows the dates that are in the 4th calendar quarter, regardless of year. |
ThisMonth | Shows this month's dates. |
ThisQuarter | Shows this calendar quarter's dates. |
ThisWeek | Shows this week's dates, using Sunday as the first weekday. |
ThisYear | Shows this year's dates. |
Today | Shows today's dates. |
Tomorrow | Shows tomorrow's dates. |
YearToDate | Shows the dates between the beginning of the year and today, inclusive. |
Yesterday | Shows yesterday's dates. |