aspose.cells

Class DynamicFilterType

Utility class containing constants. Dynamic filter type.

Field Summary
const  NumberABOVE_AVERAGE
Shows values that are above average.
const  NumberBELOW_AVERAGE
Shows values that are below average.
const  NumberLAST_MONTH
Shows last month's dates.
const  NumberLAST_QUARTER
Shows last quarter's dates.
const  NumberLAST_WEEK
Shows last week's dates.
const  NumberLAST_YEAR
Shows last year's dates.
const  NumberJANUARY
Shows the dates that are in January, regardless of year.
const  NumberOCTOBER
Shows the dates that are in October, regardless of year.
const  NumberNOVEMBER
Shows the dates that are in November, regardless of year.
const  NumberDECEMBER
Shows the dates that are in December, regardless of year.
const  NumberFEBRUARY
Shows the dates that are in February, regardless of year.
const  NumberMARCH
Shows the dates that are in March, regardless of year.
const  NumberAPRIL
Shows the dates that are in April, regardless of year.
const  NumberMAY
Shows the dates that are in May, regardless of year.
const  NumberJUNE
Shows the dates that are in June, regardless of year.
const  NumberJULY
Shows the dates that are in July, regardless of year.
const  NumberAUGUST
Shows the dates that are in August, regardless of year.
const  NumberSEPTEMBER
Shows the dates that are in September, regardless of year.
const  NumberNEXT_MONTH
Shows next month's dates.
const  NumberNEXT_QUARTER
Shows next quarter's dates.
const  NumberNEXT_WEEK
Shows next week's dates.
const  NumberNEXT_YEAR
Shows next year's dates.
const  NumberNONE
None.
const  NumberQUARTER_1
Shows the dates that are in the 1st quarter, regardless of year.
const  NumberQUARTER_2
Shows the dates that are in the 2nd quarter, regardless of year.
const  NumberQUARTER_3
Shows the dates that are in the 3rd quarter, regardless of year.
const  NumberQUARTER_4
Shows the dates that are in the 4th quarter, regardless of year.
const  NumberTHIS_MONTH
Shows this month's dates.
const  NumberTHIS_QUARTER
Shows this quarter's dates.
const  NumberTHIS_WEEK
Shows this week's dates.
const  NumberTHIS_YEAR
Shows this year's dates.
const  NumberTODAY
Shows today's dates.
const  NumberTOMORROW
Shows tomorrow's dates.
const  NumberYEAR_TO_DATE
Shows the dates between the beginning of the year and today, inclusive.
const  NumberYESTERDAY
Shows yesterday's dates.
 

    • Field Detail

      • ABOVE_AVERAGE

        const Number ABOVE_AVERAGE
        Shows values that are above average.
      • BELOW_AVERAGE

        const Number BELOW_AVERAGE
        Shows values that are below average.
      • LAST_MONTH

        const Number LAST_MONTH
        Shows last month's dates.
      • LAST_QUARTER

        const Number LAST_QUARTER
        Shows last quarter's dates.
      • LAST_WEEK

        const Number LAST_WEEK
        Shows last week's dates.
      • LAST_YEAR

        const Number LAST_YEAR
        Shows last year's dates.
      • JANUARY

        const Number JANUARY
        Shows the dates that are in January, regardless of year.
      • OCTOBER

        const Number OCTOBER
        Shows the dates that are in October, regardless of year.
      • NOVEMBER

        const Number NOVEMBER
        Shows the dates that are in November, regardless of year.
      • DECEMBER

        const Number DECEMBER
        Shows the dates that are in December, regardless of year.
      • FEBRUARY

        const Number FEBRUARY
        Shows the dates that are in February, regardless of year.
      • MARCH

        const Number MARCH
        Shows the dates that are in March, regardless of year.
      • APRIL

        const Number APRIL
        Shows the dates that are in April, regardless of year.
      • MAY

        const Number MAY
        Shows the dates that are in May, regardless of year.
      • JUNE

        const Number JUNE
        Shows the dates that are in June, regardless of year.
      • JULY

        const Number JULY
        Shows the dates that are in July, regardless of year.
      • AUGUST

        const Number AUGUST
        Shows the dates that are in August, regardless of year.
      • SEPTEMBER

        const Number SEPTEMBER
        Shows the dates that are in September, regardless of year.
      • NEXT_MONTH

        const Number NEXT_MONTH
        Shows next month's dates.
      • NEXT_QUARTER

        const Number NEXT_QUARTER
        Shows next quarter's dates.
      • NEXT_WEEK

        const Number NEXT_WEEK
        Shows next week's dates.
      • NEXT_YEAR

        const Number NEXT_YEAR
        Shows next year's dates.
      • NONE

        const Number NONE
        None.
      • QUARTER_1

        const Number QUARTER_1
        Shows the dates that are in the 1st quarter, regardless of year.
      • QUARTER_2

        const Number QUARTER_2
        Shows the dates that are in the 2nd quarter, regardless of year.
      • QUARTER_3

        const Number QUARTER_3
        Shows the dates that are in the 3rd quarter, regardless of year.
      • QUARTER_4

        const Number QUARTER_4
        Shows the dates that are in the 4th quarter, regardless of year.
      • THIS_MONTH

        const Number THIS_MONTH
        Shows this month's dates.
      • THIS_QUARTER

        const Number THIS_QUARTER
        Shows this quarter's dates.
      • THIS_WEEK

        const Number THIS_WEEK
        Shows this week's dates.
      • THIS_YEAR

        const Number THIS_YEAR
        Shows this year's dates.
      • TODAY

        const Number TODAY
        Shows today's dates.
      • TOMORROW

        const Number TOMORROW
        Shows tomorrow's dates.
      • YEAR_TO_DATE

        const Number YEAR_TO_DATE
        Shows the dates between the beginning of the year and today, inclusive.
      • YESTERDAY

        const Number YESTERDAY
        Shows yesterday's dates.