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 [EMAIL PROTECTED] 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
