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 occuring in this calendar month.
const  NumberLAST_MONTH
A date occuring in the last calendar month.
const  NumberNEXT_MONTH
A date occuring in the next calendar month.
const  NumberTHIS_WEEK
A date occuring this week.
const  NumberLAST_WEEK
A date occuring last week.
const  NumberNEXT_WEEK
A date occuring next week.
 

    • 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 occuring in this calendar month.
      • LAST_MONTH

        const Number LAST_MONTH
        A date occuring in the last calendar month.
      • NEXT_MONTH

        const Number NEXT_MONTH
        A date occuring in the next calendar month.
      • THIS_WEEK

        const Number THIS_WEEK
        A date occuring this week.
      • LAST_WEEK

        const Number LAST_WEEK
        A date occuring last week.
      • NEXT_WEEK

        const Number NEXT_WEEK
        A date occuring next week.