aspose.cells

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.