poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Blake Watson <blake.wat...@pnmac.com>
Subject Value vs. DateValue
Date Mon, 11 Dec 2017 23:32:03 GMT
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.watson@pnmac.com
www.PennyMacUSA.com <http://www.pennymacusa.com/>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message