Spread WPF 17
GrapeCity.Excel Namespace / ExcelDynamicFilterType Enumeration


In This Topic
    ExcelDynamicFilterType Enumeration
    In This Topic
    Dynamic filter types
    Syntax
    'Declaration
 
Public Enum ExcelDynamicFilterType 
   Inherits System.Enum
    'Usage
 
Dim instance As ExcelDynamicFilterType
    public enum ExcelDynamicFilterType : System.Enum
    Members
    MemberDescription
    AboveAverageShows values that are above average.
    BelowAverageShows values that are below average.
    LastMonthShows Last month's dates.
    LastQuarterShows last quarter's dates.
    LastWeekShows last week's dates.
    LastYearShows last year's dates.
    M1Shows the dates that are in January, regardless of year
    M10Shows the dates that are in October, regardless of year
    M11Shows the dates that are in November, regardless of year
    M12Shows the dates that are in December, regardless of year
    M2Shows the dates that are in February, regardless of year
    M3Shows the dates that are in March, regardless of year
    M4Shows the dates that are in April, regardless of year
    M5Shows the dates that are in May, regardless of year
    M6Shows the dates that are in June, regardless of year
    M7Shows the dates that are in July, regardless of year
    M8Shows the dates that are in August, regardless of year
    M9Shows the dates that are in September, regardless of year
    NextMonthShows next month's dates.
    NextQuarterShows next quarter's dates.
    NextWeekShows next week's dates.
    NextYearShows next year's dates.
    NullThe type has not been specified.
    Q1Shows the dates that are in the 1st quarter, regardless of year.
    Q2Shows the dates that are in the 2nd quarter, regardless of year.
    Q3Shows the dates that are in the 3rd quarter, regardless of year.
    Q4Shows the dates that are in the 4th quarter, regardless of year.
    ThisMonthShows this month's dates.
    ThisQuarterShows this quarter's dates.
    ThisWeekShows this week's dates.
    ThisYearShows this year's dates.
    TodayShows today's dates.
    TomorrowShows tomorrow's dates.
    YearToDateShows the dates between the beginning of the year and today, inclusive.
    YesterdayShows yesterday's dates
    Inheritance Hierarchy

    System.Object
       System.ValueType
          System.Enum
             GrapeCity.Excel.ExcelDynamicFilterType

    See Also

    Reference

    GrapeCity.Excel Namespace