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/03/29 13:54:10 UTC
[Bug 54767] New: Need to express non-existent date
https://issues.apache.org/bugzilla/show_bug.cgi?id=54767
Bug ID: 54767
Summary: Need to express non-existent date
Product: POI
Version: 3.8
Hardware: PC
OS: Windows Server 2003
Status: NEW
Severity: normal
Priority: P2
Component: POI Overall
Assignee: dev@poi.apache.org
Reporter: i8c.alex@gmail.com
Classification: Unclassified
--
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 54767] Need to express non-existent date
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=54767
Nick Burch <ap...@gagravarr.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |RESOLVED
Resolution|--- |INVALID
--- Comment #2 from Nick Burch <ap...@gagravarr.org> ---
Please ask usage questions on the mailing lists -
http://poi.apache.org/mailinglists.html
--
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 54767] Need to express non-existent date
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=54767
--- Comment #1 from alex <i8...@gmail.com> ---
I have a requirement that does not seem easy to implement:
The jvm uses Europe/Paris as its default timezone.
We need to put a list of dates into the excel and the list contains an hour
that does not exist in that timezone: 2013-03-31T02:00:00
If we have a list of date objects which contain say "01:00, 02:00, 03:00", the
excel will show "01:00, 03:00, 04:00" because the internal calendar uses the
default timezone.
Our current workaround is to inject the dates not as java.util.Date objects but
rather as numbers. To transform the dates to numbers we use the method
org.apache.poi.ss.usermodel.DateUtil.getExcelDate(Calendar date, boolean
use1904windowing) and pass in a calendar that is set in UTC.
Am I missing something? Can I change the timezone of the internal Calendar or
am I doing something wrong? Is it possible to expose the timezone settings of
said calendar instead of using the default one?
--
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