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 2012/01/04 13:43:47 UTC

DO NOT REPLY [Bug 48528] An Error in Date() function

https://issues.apache.org/bugzilla/show_bug.cgi?id=48528

brezelman@yahoo.de changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |brezelman@yahoo.de

--- Comment #9 from brezelman@yahoo.de 2012-01-04 12:43:47 UTC ---
This bug is still present in poi 3.7 final. Excel interprets carries in the
date formula function, e.g. DATE(2012;MONTH(TODAY())-1;1) is evaluated to
2011-12-01 in January; DATE(2012;MONTH(TODAY())-13;1) is evaluated to
2010-12-01 then. It's the same with positive values and for carries at the date
value.

-- 
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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org