You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by bu...@apache.org on 2013/04/30 13:35:51 UTC
[Bug 54909] New: DataFormatter takes daylight saving time into
account
https://issues.apache.org/bugzilla/show_bug.cgi?id=54909
Bug ID: 54909
Summary: DataFormatter takes daylight saving time into account
Product: POI
Version: unspecified
Hardware: PC
Status: NEW
Severity: normal
Priority: P2
Component: XSSF
Assignee: dev@poi.apache.org
Reporter: j_handrick@hotmail.de
Classification: Unclassified
When the DataFormatter formats a date, it sometimes does not display the value
from the view in Excel. Daylight Saving Time started on March 31st 2013. In
Excel it displays 31.03.2013 02:00:00, while the DataFormatter formats it to
31.03.2013 03:00:00. After that, the date is displayed as in the view (for
example 31.03.2013 04:00:00).
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 54909] DataFormatter takes daylight saving time into account
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=54909
Nick Burch <ap...@gagravarr.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
OS| |All
--- Comment #2 from Nick Burch <ap...@gagravarr.org> ---
DataFormatter largely relies on the underlying Java Date Formatter classes,
which in turn will depend on the system timezone. Could it be that your system
isn't in the same timezone you expect?
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 54909] DataFormatter takes daylight saving time into account
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=54909
--- Comment #1 from j_handrick@hotmail.de ---
Created attachment 30243
--> https://issues.apache.org/bugzilla/attachment.cgi?id=30243&action=edit
unit test
Unit test showing different DataFormatter formattings
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 54909] DataFormatter takes daylight saving time into account
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=54909
--- Comment #3 from Nick Burch <ap...@gagravarr.org> ---
FYI I've just tried your unit test on a machine set to a UK locale + timezone,
and it passes just fine
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org