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  NumberFEBRURAY
           Shows the dates that are in Februray, 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
          
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.

FEBRURAY

const Number FEBRURAY
Shows the dates that are in Februray, 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

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.

See Also:
          Aspose.Cells Documentation - the home page for the Aspose.Cellss Product Documentation.
          Aspose.Cells Support Forum - our preferred method of support.