TimePeriodType
TimePeriodType enumeration
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 TimePeriodType
Values
| Name | Value | Description |
|---|---|---|
| Today | 0 |
Today’s date. |
| Yesterday | 1 |
Yesterday’s date. |
| Tomorrow | 2 |
Tomorrow’s date. |
| Last7Days | 3 |
A date in the last seven days. |
| ThisMonth | 4 |
A date occurring in this calendar month. |
| LastMonth | 5 |
A date occurring in the last calendar month. |
| NextMonth | 6 |
A date occurring in the next calendar month. |
| ThisWeek | 7 |
A date occurring this week. |
| LastWeek | 8 |
A date occurring last week. |
| NextWeek | 9 |
A date occurring next week. |
| ThisYear | 10 |
A date occurring this year. Only for .ods. |
| LastYear | 11 |
A date occurring last year. Only for .ods. |
| NextYear | 12 |
A date occurring next year. Only for .ods. |
See Also
- namespace Aspose.Cells
- assembly Aspose.Cells
