poi-general mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Nick Burch <n...@torchbox.com>
Subject Re: FW: calculation Problem by generation Excel-sheets (under Win-XP JBoss4.0)
Date Tue, 11 Dec 2007 14:54:04 GMT
On Tue, 11 Dec 2007, Viktor Dalinger wrote:
> The Excel-formula, that are stored in one Excel-worksheet and referenced 
> to some other Excel-worksheets, will not be refreshed / calculated after 
> opening of the document.

You will need to either re-calculate the formula values, or add a macro to 
your sheet to tell excel to do it for you. Otherwise, excel will just 
display the previous (cached) value without updating it.

See http://poi.apache.org/hssf/eval.html for details about how to 
re-calculate

Also, this sort of question would be better asked on the users list

Nick

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


Mime
View raw message