You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by bu...@apache.org on 2016/01/17 09:14:21 UTC
[Bug 58877] Cannot get a numeric value from a error formula cell
https://bz.apache.org/bugzilla/show_bug.cgi?id=58877
Nick Burch <ap...@gagravarr.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Resolution|--- |INVALID
Status|NEW |RESOLVED
--- Comment #1 from Nick Burch <ap...@gagravarr.org> ---
For formula cells, you need to check the cached formula result type, and fetch
the cell's value based on that -
https://poi.apache.org/apidocs/org/apache/poi/ss/usermodel/Cell.html#getCachedFormulaResultType%28%29
. You cannot blindly fetch the numeric value for formula cells, as many
formulas don't resolve to numbers, eg they give a String or an Error (as in
your case)
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org