After evaluator.evaluateAll() the value of TODAY() is calculated as 20160004 instead of 20160104 (Format yyyymmdd)
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.
Created attachment 33489 [details] Screenshot 1 Screenshot of how date is displayed in XL
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
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
=TEXT(TODAY(),"yyyymmdd") formula used in excel to format the date.
Pls download the code from below link to reproduce the problem. https://drive.google.com/file/d/0BybOGNd-PrBsOFpVSHVDVmhNMGc/view?usp=sharing