poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mark Beardsley <markbrd...@tiscali.co.uk>
Subject Re: to obtain value of cellx.setCellFormula("SUM(I3:I20)");
Date Fri, 09 Mar 2012 16:13:29 GMT
If you want to obtain the value calculated/determined by a formula after you
have updated on of it's dependent cells on a sheet, then you need to to use
the formula evaluator. Take a look here -
http://poi.apache.org/spreadsheet/eval.html

--
View this message in context: http://apache-poi.1045710.n5.nabble.com/to-obtain-value-of-cellx-setCellFormula-SUM-I3-I20-tp5546613p5551040.html
Sent from the POI - User mailing list archive at Nabble.com.

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


Mime
View raw message