Enum TimePeriodType
Namespace: Aspose.Cells
Assembly: Aspose.Cells.dll (25.2.0)
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.
public enum TimePeriodTypeFields
Last7Days = 3
A date in the last seven days.
LastMonth = 5
A date occurring in the last calendar month.
LastWeek = 8
A date occurring last week.
LastYear = 11
A date occurring last year. Only for .ods.
NextMonth = 6
A date occurring in the next calendar month.
NextWeek = 9
A date occurring next week.
NextYear = 12
A date occurring next year. Only for .ods.
ThisMonth = 4
A date occurring in this calendar month.
ThisWeek = 7
A date occurring this week.
ThisYear = 10
A date occurring this year. Only for .ods.
Today = 0
Today’s date.
Tomorrow = 2
Tomorrow’s date.
Yesterday = 1
Yesterday’s date.