TimePeriodType

Inheritance: java.lang.Object

public final class TimePeriodType

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.

Fields

FieldDescription
LAST_7_DAYSA date in the last seven days.
LAST_MONTHA date occurring in the last calendar month.
LAST_WEEKA date occurring last week.
LAST_YEARA date occurring last year.
NEXT_MONTHA date occurring in the next calendar month.
NEXT_WEEKA date occurring next week.
NEXT_YEARA date occurring next year.
THIS_MONTHA date occurring in this calendar month.
THIS_WEEKA date occurring this week.
THIS_YEARA date occurring this year.
TODAYToday’s date.
TOMORROWTomorrow’s date.
YESTERDAYYesterday’s date.

Methods

MethodDescription
equals(Object arg0)
getClass()
hashCode()
notify()
notifyAll()
toString()
wait()
wait(long arg0)
wait(long arg0, int arg1)

LAST_7_DAYS

public static final int LAST_7_DAYS

A date in the last seven days.

LAST_MONTH

public static final int LAST_MONTH

A date occurring in the last calendar month.

LAST_WEEK

public static final int LAST_WEEK

A date occurring last week.

LAST_YEAR

public static final int LAST_YEAR

A date occurring last year. Only for .ods.

NEXT_MONTH

public static final int NEXT_MONTH

A date occurring in the next calendar month.

NEXT_WEEK

public static final int NEXT_WEEK

A date occurring next week.

NEXT_YEAR

public static final int NEXT_YEAR

A date occurring next year. Only for .ods.

THIS_MONTH

public static final int THIS_MONTH

A date occurring in this calendar month.

THIS_WEEK

public static final int THIS_WEEK

A date occurring this week.

THIS_YEAR

public static final int THIS_YEAR

A date occurring this year. Only for .ods.

TODAY

public static final int TODAY

Today’s date.

TOMORROW

public static final int TOMORROW

Tomorrow’s date.

YESTERDAY

public static final int YESTERDAY

Yesterday’s date.

equals(Object arg0)

public boolean equals(Object arg0)

Parameters:

ParameterTypeDescription
arg0java.lang.Object

Returns: boolean

getClass()

public final native Class<?> getClass()

Returns: java.lang.Class

hashCode()

public native int hashCode()

Returns: int

notify()

public final native void notify()

notifyAll()

public final native void notifyAll()

toString()

public String toString()

Returns: java.lang.String

wait()

public final void wait()

wait(long arg0)

public final native void wait(long arg0)

Parameters:

ParameterTypeDescription
arg0long

wait(long arg0, int arg1)

public final void wait(long arg0, int arg1)

Parameters:

ParameterTypeDescription
arg0long
arg1int