In Excel, if I have a cell with any of these:
=VALUE("12-1-2017")
=VALUE("2017/11/05")
=VALUE("03/31/2015")
Excel recognizes it's a date and returns the appropriate Double. In POI,
if I evaluate the cell, I get an error back. Looking at the code (and
documentation) for Value, it seems as though POI expects a non-date number.
There's also DateValue, of course.
I think, Value should evaluate as Excel's VALUE function does. Unless I
miss something. In any event, VALUE in a cell should be something that POI
should be able to catch.
--
*Blake Watson*
*PNMAC*
Application Development Manager
5898 Condor Drive
Moorpark, CA 93021
(805) 330.4911 x7742
blake.wat...@pnmac.com
www.PennyMacUSA.com <http://www.pennymacusa.com/>
