Bug 58796

Summary:	After using evaluator.evaluateAll() date is calculated incorrectly
Product:	POI	Reporter:	Anubhav Bansal <anbansal>
Component:	XSSF	Assignee:	POI Developers List <dev>
Status:	NEW ---
Severity:	normal	CC:	anbansal
Priority:	P2
Version:	unspecified
Target Milestone:	---
Hardware:	PC
OS:	Linux
Attachments:	Screenshot 1 Screenshot 2

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