asposecells.api

asposecells.api

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  intTODAY
Today's date.
const  intYESTERDAY
Yesterday's date.
const  intTOMORROW
Tomorrow's date.
const  intLAST_7_DAYS
A date in the last seven days.
const  intTHIS_MONTH
A date occurring in this calendar month.
const  intLAST_MONTH
A date occurring in the last calendar month.
const  intNEXT_MONTH
A date occurring in the next calendar month.
const  intTHIS_WEEK
A date occurring this week.
const  intLAST_WEEK
A date occurring last week.
const  intNEXT_WEEK
A date occurring next week.
const  intTHIS_YEAR
A date occurring this year. Only for .ods.
const  intLAST_YEAR
A date occurring last year. Only for .ods.
const  intNEXT_YEAR
A date occurring next year. Only for .ods.
 

    • Field Detail

      • TODAY

        const int TODAY
        Today's date.

      • YESTERDAY

        const int YESTERDAY
        Yesterday's date.

      • TOMORROW

        const int TOMORROW
        Tomorrow's date.

      • LAST_7_DAYS

        const int LAST_7_DAYS
        A date in the last seven days.

      • THIS_MONTH

        const int THIS_MONTH
        A date occurring in this calendar month.

      • LAST_MONTH

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

      • NEXT_MONTH

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

      • THIS_WEEK

        const int THIS_WEEK
        A date occurring this week.

      • LAST_WEEK

        const int LAST_WEEK
        A date occurring last week.

      • NEXT_WEEK

        const int NEXT_WEEK
        A date occurring next week.

      • THIS_YEAR

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

      • LAST_YEAR

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

      • NEXT_YEAR

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