Aspose::Cells::DynamicFilterType enum

DynamicFilterType enum

Dynamic filter type.

enum class DynamicFilterType

Values

NameValueDescription
AboveAverage0
Shows values that are above average.
BelowAverage1
Shows values that are below average.
LastMonth2
Shows last month’s dates.
LastQuarter3
Shows last quarter’s dates.
LastWeek4
Shows last week’s dates.
LastYear5
Shows last year’s dates.
January6
Shows the dates that are in January, regardless of year.
October7
Shows the dates that are in October, regardless of year.
November8
Shows the dates that are in November, regardless of year.
December9
Shows the dates that are in December, regardless of year.
February10
Shows the dates that are in February, regardless of year.
March11
Shows the dates that are in March, regardless of year.
April12
Shows the dates that are in April, regardless of year.
May13
Shows the dates that are in May, regardless of year.
June14
Shows the dates that are in June, regardless of year.
July15
Shows the dates that are in July, regardless of year.
August16
Shows the dates that are in August, regardless of year.
September17
Shows the dates that are in September, regardless of year.
NextMonth18
Shows next month’s dates.
NextQuarter19
Shows next quarter’s dates.
NextWeek20
Shows next week’s dates.
NextYear21
Shows next year’s dates.
None22
None.
Quarter123
Shows the dates that are in the 1st quarter, regardless of year.
Quarter224
Shows the dates that are in the 2nd quarter, regardless of year.
Quarter325
Shows the dates that are in the 3rd quarter, regardless of year.
Quarter426
Shows the dates that are in the 4th quarter, regardless of year.
ThisMonth27
Shows this month’s dates.
ThisQuarter28
Shows this quarter’s dates.
ThisWeek29
Shows this week’s dates.
ThisYear30
Shows this year’s dates.
Today31
Shows today’s dates.
Tomorrow32
Shows tomorrow’s dates.
YearToDate33
Shows the dates between the beginning of the year and today, inclusive.
Yesterday34
Shows yesterday’s dates.

See Also