https://issues.apache.org/bugzilla/show_bug.cgi?id=46411
Summary: Formatting of Excel date values < 1.0 show different
date to Excel
Product: POI
Version: 3.5-dev
Platform: PC
OS/Version: Windows XP
Status: NEW
Severity: minor
Priority: P2
Component: HSSF
AssignedTo: [email protected]
ReportedBy: [email protected]
In Excel 2003, when a TIME(h,m,s) value is formatted as a date, or includes a
date component. For example, when TIME(12,0,0) is formatted with the format
string "yyyy-mm-dd hh:mm:ss", the date is shown as
1900-01-00 12:00:00 in Excel.
This is obviously not a correct date but it is what Excel does with the value.
POI formats the value as
1899-12-31 12:00:00
which is a valid date, but not the same as the value produced by Excel.
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
