poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Nick Burch <apa...@gagravarr.org>
Subject Re: Formula not working as expected
Date Thu, 05 Nov 2015 23:36:20 GMT
On Thu, 5 Nov 2015, Jason Tomforde wrote:
> A1 string cell = 1
> A2 numeric cell = 2
> A3 numeric cell = 3
> A4 formula cell = IF(A1=1,A2,A3)
>
> The result I am getting is 0.
>
> Any thoughts?

Are you evaluating the formula when you're doing with settings cells? 
http://poi.apache.org/spreadsheet/eval.html

Are you using a new enough version of Apache POI? 
http://poi.apache.org/download.html

Nick

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org


Mime
View raw message