Created attachment 31580 [details] An example Java program and spreadsheet to demonstrate the issue When using the TEXT function and combining it with the NOW function as its value, the POI FormulaEvaluator works fine when dealing with a standard format e.g: =TEXT(NOW();"yyyy-MM-ddhh-mm-ss") Excel output = 2014-05-0114-25-35 POI output = 2014-05-0114-25-35 When the format contains a less typical value however, the string value returned is the unformatted output of NOW(). For example, the case we have (and demonstrated in the attached program) is when the format contains a 'T': =TEXT(NOW();"yyyy-MM-ddThh-mm-ss") Excel output = 2014-05-01T14-24-17 POI output = 41760.60074957176 Thanks, James
We've had a few fixes in this sort of area since you reported this, any chance you could retest with 3.13 final (or even better a nightly build / svn checkout build), and let us know if the problem still remains?
There was no response for a very long time and I could not reproduce this locally, the test-code actually results in #VALUE and LibreOffice formats the date in a very strange way, unfortunately I do not have MSOffice available right now. If this is still a problem with the latest version of Apache POI (currently 4.0.1) then please reopen this bug-report with some more information.