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 Tue, 20 Nov 2007 15:10:03 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





------- Additional Comments From aktizol@gmail.com  2007-11-20 07:10 -------
(In reply to comment #1)
> [copying and pasting from a mail which I just sent to the mailing list]
> 
> Hello,
> 
> what exactly is an IterationRecord for?
>
http://jakarta.apache.org/poi/apidocs/org/apache/poi/hssf/record/IterationRecord.html
> 
> I especially wonder why it's set to false upon document creation, as the
> description somehow seems like it would control whether depending formulas are
> recalculated upon modification of cells/other formulas.
> 
> The reason why I'm interested is because I have a document where formulas aren't
> recalculated. After modifying the cells on which the formulas depend and saving
> the document (JXLS does that using POI), the formula cells still show their old
> value before modification.
> 
> I can trigger recalculation by pressing F2 or somehow modifying the formulas, or
> at least pretending to do so. For example, searching and replacing '=' with '='
> (yes, same character) in a sheet will update the formulas to their correct value.
> 
> However, it's an existing document, so maybe createIteration() isn't even
> called. Maybe it's still connected to the IterationRecord?
> 
> That issue wasn't present in POI 2.5.1.
> 
> I also added a bug: http://issues.apache.org/bugzilla/show_bug.cgi?id=41971
> 
> Regards,
> Julien

yes, I have the same problem here, with 2.5.1 everything is fine.
another workaround is to pres CTRL+SHIFT+F9 or to record a macro with VBA to
recalculate all fields on document start.


-- 
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