Click or drag to resize
DynamicFilterType Enumeration
Dynamic filter type.

Namespace: Aspose.Cells
Assembly: Aspose.Cells (in Aspose.Cells.dll) Version: 19.9.0.0 (19.9)
Syntax
public enum DynamicFilterType
Members
  Member 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.
Februray10 Shows the dates that are in Februray, 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
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