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: [email protected]
For additional commands, e-mail: [email protected]
