poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject DO NOT REPLY [Bug 41971] - Excel doesn't reevaluate formula cells, worked with 2.5.1
Date Thu, 24 Jan 2008 15:44:06 GMT
DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG·
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://issues.apache.org/bugzilla/show_bug.cgi?id=41971>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND·
INSERTED IN THE BUG DATABASE.

http://issues.apache.org/bugzilla/show_bug.cgi?id=41971


nick@torchbox.com changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|REOPENED                    |RESOLVED
         Resolution|                            |FIXED




------- Additional Comments From nick@torchbox.com  2008-01-24 07:44 -------
(In reply to comment #7)
> The evaluateInCell Method removes the original formulas and replaces it with
the result value. The 
> resulting excel is unusable for our client.

Ah, so it does, my bad :( Sorry about that

I've updated the docs at <http://poi.apache.org/hssf/eval.html#EvaluateAll>

You'll want a svn checkout for evaluator.evaluateFormulaCell(c), but that should
do what you want (I even wrote a test to check that!). Also, with a svn
checkout, there's a new flag on a sheet to allow you to request a complete
formula re-evaluation from excel on the next load. That might also work for you

-- 
Configure bugmail: http://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug, or are watching the assignee.

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


Mime
View raw message