Aspose::Cells::TimePeriodType enum

TimePeriodType enum

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.

enum class TimePeriodType

Values

NameValueDescription
Today0
Today’s date.
Yesterday1
Yesterday’s date.
Tomorrow2
Tomorrow’s date.
Last7Days3
A date in the last seven days.
ThisMonth4
A date occurring in this calendar month.
LastMonth5
A date occurring in the last calendar month.
NextMonth6
A date occurring in the next calendar month.
ThisWeek7
A date occurring this week.
LastWeek8
A date occurring last week.
NextWeek9
A date occurring next week.
ThisYear10
A date occurring this year. Only for .ods.
LastYear11
A date occurring last year. Only for .ods.
NextYear12
A date occurring next year. Only for .ods.

See Also