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 2016/09/22 12:40:42 UTC
[Bug 60165] New: negative dates
https://bz.apache.org/bugzilla/show_bug.cgi?id=60165
Bug ID: 60165
Summary: negative dates
Product: POI
Version: unspecified
Hardware: All
OS: All
Status: NEW
Severity: major
Priority: P2
Component: SS Common
Assignee: dev@poi.apache.org
Reporter: v.smeltsov@intechcore.de
--
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 60165] negative dates in poi for java application doesn't
supported?
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=60165
Nick Burch <ap...@gagravarr.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |NEEDINFO
--- Comment #5 from Nick Burch <ap...@gagravarr.org> ---
Can you please write a short junit unit test that highlights the problem? With
no code, we have a very low chance of being able to fix bugs (if any)....
--
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 60165] negative dates in poi for java application doesn't
supported?
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=60165
--- Comment #6 from Javen O'Neal <on...@apache.org> ---
Possibly relevant:
https://svn.apache.org/viewvc/poi/trunk/src/testcases/org/apache/poi/ss/usermodel/TestDateUtil.java?view=markup
I believe POI supports 1900 dates, which is what Microsoft Excel uses. The
xls/xslx format cannot represent earlier dates.
Search the developer list and pasy bugs. I think this question has come up
before for users trying to represent medieval and BC dates.
https://support.office.com/en-us/article/DATE-function-e36c0c8c-4104-49da-ab83-82328b832349
--
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 60165] negative dates
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=60165
--- Comment #1 from Vasily S <v....@intechcore.de> ---
Created attachment 34291
--> https://bz.apache.org/bugzilla/attachment.cgi?id=34291&action=edit
negative dates in excel and scell
Example how it looks in excel and scell. Scell can be downloaded from
http://scell.org/download.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 60165] negative dates in poi for java application doesn't
supported?
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=60165
Dominik Stadler <do...@gmx.at> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEEDINFO |NEW
--
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 60165] negative dates in poi for java application doesn't
supported?
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=60165
--- Comment #4 from Vasily S <v....@intechcore.de> ---
It needs the support of the POI library: use 1904 date system
--
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 60165] negative dates in poi for java application doesn't
supported?
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=60165
--- Comment #7 from Vasily S <v....@intechcore.de> ---
Created attachment 34308
--> https://bz.apache.org/bugzilla/attachment.cgi?id=34308&action=edit
junit test and small description of problem
look at attached document with junit test and small description of problem.
--
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 60165] negative dates in poi for java application doesn't
supported?
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=60165
--- Comment #2 from Vasily S <v....@intechcore.de> ---
it seeams, that negative dates don't supported in actuall version of poi.
--
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 60165] negative dates in java application doesn't supported?
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=60165
Vasily S <v....@intechcore.de> changed:
What |Removed |Added
----------------------------------------------------------------------------
Keywords| |APIBug
Summary|negative dates |negative dates in java
| |application doesn't
| |supported?
--
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 60165] negative dates in poi for java application doesn't
supported?
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=60165
--- Comment #3 from Vasily S <v....@intechcore.de> ---
Created attachment 34292
--> https://bz.apache.org/bugzilla/attachment.cgi?id=34292&action=edit
Example xlsx for negative date
load file in excel and in java with poi and look at F39
--
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 60165] negative dates in poi for java application doesn't
supported?
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=60165
Dominik Stadler <do...@gmx.at> changed:
What |Removed |Added
----------------------------------------------------------------------------
Depends on| |45531, 46411
--- Comment #8 from Dominik Stadler <do...@gmx.at> ---
This is related or even a duplicate of bug 45531 and bug 46411
--
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 60165] negative dates in poi for java application doesn't
supported?
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=60165
Vasily S <v....@intechcore.de> changed:
What |Removed |Added
----------------------------------------------------------------------------
Summary|negative dates in java |negative dates in poi for
|application doesn't |java application doesn't
|supported? |supported?
--
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