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/01/04 12:26:11 UTC
[Bug 58796] New: After using evaluator.evaluateAll() date is
calculated incorrectly
https://bz.apache.org/bugzilla/show_bug.cgi?id=58796
Bug ID: 58796
Summary: After using evaluator.evaluateAll() date is calculated
incorrectly
Product: POI
Version: unspecified
Hardware: PC
OS: Linux
Status: NEW
Severity: normal
Priority: P2
Component: XSSF
Assignee: dev@poi.apache.org
Reporter: anbansal@gmail.com
After evaluator.evaluateAll() the value of TODAY() is calculated as
20160004 instead of
20160104 (Format yyyymmdd)
--
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 58796] After using evaluator.evaluateAll() date is calculated
incorrectly
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=58796
Anubhav Bansal <an...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEEDINFO |NEW
--- Comment #4 from Anubhav Bansal <an...@gmail.com> ---
The simple TODAT() function is read well but when there is TEXT() used to
format the date then there is error with month value. Pls see the attached
screenshot
Screenshot 1 : Screenshot of how date is displayed in XL
Screenshot 2 : Screenshot from eclipse for how it is read in java code, you
will see that month is read as 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 58796] After using evaluator.evaluateAll() date is calculated
incorrectly
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=58796
Anubhav Bansal <an...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |anbansal@gmail.com
--
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 58796] After using evaluator.evaluateAll() date is calculated
incorrectly
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=58796
Dominik Stadler <do...@gmx.at> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |NEEDINFO
--- Comment #1 from Dominik Stadler <do...@gmx.at> ---
Please provide a bit more information, ideally a self-sufficient piece of
test-code (unit-test) together with any sample files that are needed. This will
make it much easier for others to reproduce/analyze your 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 58796] After using evaluator.evaluateAll() date is calculated
incorrectly
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=58796
--- Comment #2 from Anubhav Bansal <an...@gmail.com> ---
Created attachment 33489
--> https://bz.apache.org/bugzilla/attachment.cgi?id=33489&action=edit
Screenshot 1
Screenshot of how date is displayed in XL
--
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 58796] After using evaluator.evaluateAll() date is calculated
incorrectly
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=58796
--- Comment #5 from Anubhav Bansal <an...@gmail.com> ---
=TEXT(TODAY(),"yyyymmdd")
formula used in excel to format the date.
--
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 58796] After using evaluator.evaluateAll() date is calculated
incorrectly
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=58796
--- Comment #6 from Anubhav Bansal <an...@gmail.com> ---
Pls download the code from below link to reproduce the problem.
https://drive.google.com/file/d/0BybOGNd-PrBsOFpVSHVDVmhNMGc/view?usp=sharing
--
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 58796] After using evaluator.evaluateAll() date is calculated
incorrectly
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=58796
--- Comment #3 from Anubhav Bansal <an...@gmail.com> ---
Created attachment 33490
--> https://bz.apache.org/bugzilla/attachment.cgi?id=33490&action=edit
Screenshot 2
Screenshot from eclipse for how it is read in java code, you will see that
month os read as 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