Package org.apache.poi.ss.usermodel
Class ExcelStyleDateFormatter
java.lang.Object
java.text.Format
java.text.DateFormat
java.text.SimpleDateFormat
org.apache.poi.ss.usermodel.ExcelStyleDateFormatter
- All Implemented Interfaces:
Serializable
,Cloneable
A wrapper around a
SimpleDateFormat
instance,
which handles a few Excel-style extensions that
are not supported by SimpleDateFormat
.
Currently, the extensions are around the handling
of elapsed time, eg rendering 1 day 2 hours
as 26 hours.- See Also:
-
Nested Class Summary
Nested classes/interfaces inherited from class java.text.DateFormat
DateFormat.Field
-
Field Summary
FieldsModifier and TypeFieldDescriptionstatic final char
static final char
static final char
static final char
static final char
static final char
static final char
static final char
static final char
static final char
Fields inherited from class java.text.DateFormat
AM_PM_FIELD, calendar, DATE_FIELD, DAY_OF_WEEK_FIELD, DAY_OF_WEEK_IN_MONTH_FIELD, DAY_OF_YEAR_FIELD, DEFAULT, ERA_FIELD, FULL, HOUR_OF_DAY0_FIELD, HOUR_OF_DAY1_FIELD, HOUR0_FIELD, HOUR1_FIELD, LONG, MEDIUM, MILLISECOND_FIELD, MINUTE_FIELD, MONTH_FIELD, numberFormat, SECOND_FIELD, SHORT, TIMEZONE_FIELD, WEEK_OF_MONTH_FIELD, WEEK_OF_YEAR_FIELD, YEAR_FIELD
-
Constructor Summary
ConstructorsConstructorDescriptionExcelStyleDateFormatter
(String pattern) ExcelStyleDateFormatter
(String pattern, DateFormatSymbols formatSymbols) ExcelStyleDateFormatter
(String pattern, Locale locale) -
Method Summary
Modifier and TypeMethodDescriptionboolean
format
(Date date, StringBuffer paramStringBuffer, FieldPosition paramFieldPosition) int
hashCode()
void
setDateToBeFormatted
(double date) Used to let us know what the date being formatted is, in Excel terms, which we may wish to use when handling elapsed times.Methods inherited from class java.text.SimpleDateFormat
applyLocalizedPattern, applyPattern, clone, formatToCharacterIterator, get2DigitYearStart, getDateFormatSymbols, parse, set2DigitYearStart, setDateFormatSymbols, toLocalizedPattern, toPattern
Methods inherited from class java.text.DateFormat
format, format, getAvailableLocales, getCalendar, getDateInstance, getDateInstance, getDateInstance, getDateTimeInstance, getDateTimeInstance, getDateTimeInstance, getInstance, getNumberFormat, getTimeInstance, getTimeInstance, getTimeInstance, getTimeZone, isLenient, parse, parseObject, setCalendar, setLenient, setNumberFormat, setTimeZone
Methods inherited from class java.text.Format
format, parseObject
-
Field Details
-
MMMMM_START_SYMBOL
public static final char MMMMM_START_SYMBOL- See Also:
-
MMMMM_TRUNCATE_SYMBOL
public static final char MMMMM_TRUNCATE_SYMBOL- See Also:
-
H_BRACKET_SYMBOL
public static final char H_BRACKET_SYMBOL- See Also:
-
HH_BRACKET_SYMBOL
public static final char HH_BRACKET_SYMBOL- See Also:
-
M_BRACKET_SYMBOL
public static final char M_BRACKET_SYMBOL- See Also:
-
MM_BRACKET_SYMBOL
public static final char MM_BRACKET_SYMBOL- See Also:
-
S_BRACKET_SYMBOL
public static final char S_BRACKET_SYMBOL- See Also:
-
SS_BRACKET_SYMBOL
public static final char SS_BRACKET_SYMBOL- See Also:
-
L_BRACKET_SYMBOL
public static final char L_BRACKET_SYMBOL- See Also:
-
LL_BRACKET_SYMBOL
public static final char LL_BRACKET_SYMBOL- See Also:
-
-
Constructor Details
-
ExcelStyleDateFormatter
-
ExcelStyleDateFormatter
-
ExcelStyleDateFormatter
-
-
Method Details
-
setDateToBeFormatted
public void setDateToBeFormatted(double date) Used to let us know what the date being formatted is, in Excel terms, which we may wish to use when handling elapsed times. -
format
public StringBuffer format(Date date, StringBuffer paramStringBuffer, FieldPosition paramFieldPosition) - Overrides:
format
in classSimpleDateFormat
-
equals
- Overrides:
equals
in classSimpleDateFormat
-
hashCode
public int hashCode()- Overrides:
hashCode
in classSimpleDateFormat
-