Bug 58796 - After using evaluator.evaluateAll() date is calculated incorrectly
Summary: After using evaluator.evaluateAll() date is calculated incorrectly
Status: NEW
Alias: None
Product: POI
Classification: Unclassified
Component: XSSF (show other bugs)
Version: unspecified
Hardware: PC Linux
: P2 normal (vote)
Target Milestone: ---
Assignee: POI Developers List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2016-01-04 11:26 UTC by Anubhav Bansal
Modified: 2017-03-29 07:29 UTC (History)
1 user (show)



Attachments
Screenshot 1 (7.23 KB, image/jpeg)
2016-01-25 12:58 UTC, Anubhav Bansal
Details
Screenshot 2 (16.80 KB, image/jpeg)
2016-01-25 12:59 UTC, Anubhav Bansal
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Anubhav Bansal 2016-01-04 11:26:11 UTC
After evaluator.evaluateAll() the value of TODAY() is calculated as 

20160004 instead of 
20160104 (Format yyyymmdd)
Comment 1 Dominik Stadler 2016-01-04 16:03:15 UTC
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.
Comment 2 Anubhav Bansal 2016-01-25 12:58:04 UTC
Created attachment 33489 [details]
Screenshot 1

Screenshot of how date is displayed in XL
Comment 3 Anubhav Bansal 2016-01-25 12:59:20 UTC
Created attachment 33490 [details]
Screenshot 2

Screenshot from eclipse for how it is read in java code, you will see that month os read as 00
Comment 4 Anubhav Bansal 2016-01-25 13:01:29 UTC
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
Comment 5 Anubhav Bansal 2016-01-28 12:40:25 UTC
=TEXT(TODAY(),"yyyymmdd")

formula used in excel to format the date.
Comment 6 Anubhav Bansal 2017-03-29 07:29:46 UTC
Pls download the code from below link to reproduce the problem.

https://drive.google.com/file/d/0BybOGNd-PrBsOFpVSHVDVmhNMGc/view?usp=sharing