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 charstatic final charstatic final charstatic final charstatic final charstatic final charstatic final charstatic final charstatic final charstatic final charFields 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 TypeMethodDescriptionbooleanformat(Date date, StringBuffer paramStringBuffer, FieldPosition paramFieldPosition) inthashCode()voidsetDateToBeFormatted(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, toPatternMethods 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, setTimeZoneMethods 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:
formatin classSimpleDateFormat
-
equals
- Overrides:
equalsin classSimpleDateFormat
-
hashCode
public int hashCode()- Overrides:
hashCodein classSimpleDateFormat
-