Help - Unable to refresh formula

["m.mail7" <m....@yahoo.co.uk>]

Hi,
My requirement is to generate the details automatically using POI.
Attached are the files for your reference.

My problem is 
Formula like =MAX(H) is not getting updated till i manually go to formula
bar (fx) and hit return. Please suggest me how to update this thru java
code.

My basic requirement is to update the Data sheet of report and copy the
updated data C19 to G20 in the same format to file a.txt at the same
location.

Please help in this regard.
Thanks in Admance.

Bye For Now
M
http://www.nabble.com/file/p20163938/MyReport.java MyReport.java 
http://www.nabble.com/file/p20163938/MyReport.xls MyReport.xls 
-- 
View this message in context: http://www.nabble.com/-GUMP%40vmgump-%3A-Project-poi-%28in-module-poi%29-failed-tp20162652p20163938.html
Sent from the POI - Dev mailing list archive at Nabble.com.


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

Re: Help - Unable to refresh formula

[Nick Burch <ni...@torchbox.com>]

On Sat, 25 Oct 2008, m.mail7 wrote:
> Formula like =MAX(H) is not getting updated till i manually go to formula
> bar (fx) and hit return. Please suggest me how to update this thru java
> code.

http://poi.apache.org/hssf/eval.html

Nick

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