aspose.cells
Class TimePeriodType

Utility class containing constants. Used in a FormatConditionType.TimePeriod conditional formatting rule. These are dynamic time periods, which change based on the date the conditional formatting is refreshed / applied.

Field Summary
const  NumberTODAY
           Today's date.
const  NumberYESTERDAY
           Yesterday's date.
const  NumberTOMORROW
           Tomorrow's date.
const  NumberLAST_7_DAYS
           A date in the last seven days.
const  NumberTHIS_MONTH
           A date occurring in this calendar month.
const  NumberLAST_MONTH
           A date occurring in the last calendar month.
const  NumberNEXT_MONTH
           A date occurring in the next calendar month.
const  NumberTHIS_WEEK
           A date occurring this week.
const  NumberLAST_WEEK
           A date occurring last week.
const  NumberNEXT_WEEK
           A date occurring next week.
const  NumberTHIS_YEAR
           A date occurring this year. Only for .ods.
const  NumberLAST_YEAR
           A date occurring last year. Only for .ods.
const  NumberNEXT_YEAR
           A date occurring next year. Only for .ods.
 

Field Detail

TODAY

const Number TODAY
Today's date.

YESTERDAY

const Number YESTERDAY
Yesterday's date.

TOMORROW

const Number TOMORROW
Tomorrow's date.

LAST_7_DAYS

const Number LAST_7_DAYS
A date in the last seven days.

THIS_MONTH

const Number THIS_MONTH
A date occurring in this calendar month.

LAST_MONTH

const Number LAST_MONTH
A date occurring in the last calendar month.

NEXT_MONTH

const Number NEXT_MONTH
A date occurring in the next calendar month.

THIS_WEEK

const Number THIS_WEEK
A date occurring this week.

LAST_WEEK

const Number LAST_WEEK
A date occurring last week.

NEXT_WEEK

const Number NEXT_WEEK
A date occurring next week.

THIS_YEAR

const Number THIS_YEAR
A date occurring this year. Only for .ods.

LAST_YEAR

const Number LAST_YEAR
A date occurring last year. Only for .ods.

NEXT_YEAR

const Number NEXT_YEAR
A date occurring next year. Only for .ods.

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