Click or drag to resize

DynamicFilterType Enumeration

Dynamic filter type.

Namespace:  Aspose.Cells
Assembly:  Aspose.Cells (in Aspose.Cells.dll) Version: 20.10.0.0 (20.10)
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 Obsolete. Shows the dates that are in February, regardless of year.
February11 Shows the dates that are in February, regardless of year.
March12 Shows the dates that are in March, regardless of year.
April13 Shows the dates that are in April, regardless of year.
May14 Shows the dates that are in May, regardless of year.
June15 Shows the dates that are in June, regardless of year.
July16 Shows the dates that are in July, regardless of year.
August17 Shows the dates that are in August, regardless of year.
September18 Shows the dates that are in September, regardless of year.
NextMonth19 Shows next month's dates.
NextQuarter20 Shows next quarter's dates.
NextWeek21 Shows next week's dates.
NextYear22 Shows next year's dates.
None23
Quarter124 Shows the dates that are in the 1st quarter, regardless of year.
Quarter225 Shows the dates that are in the 2nd quarter, regardless of year.
Quarter326 Shows the dates that are in the 3rd quarter, regardless of year.
Quarter427 Shows the dates that are in the 4th quarter, regardless of year.
ThisMonth28 Shows this month's dates.
ThisQuarter29 Shows this quarter's dates.
ThisWeek30 Shows this week's dates.
ThisYear31 Shows this year's dates.
Today32 Shows today's dates.
Tomorrow33 Shows tomorrow's dates.
YearToDate34 Shows the dates between the beginning of the year and today, inclusive.
Yesterday35 Shows yesterday's dates.
See Also