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 -- Julien Oster IT Systementwicklung terrasel software GmbH Landshuter Allee 174 80637 München tel: +49 89 178991 32 fax: +49 89 178991 50 mailto:[EMAIL PROTECTED] http://www.terrasel.de/ Geschäftsführer: Dr. Matthias Baron Registergericht München: HRB107092 Gesellschaftsitz München UID-Nr.: DE166182346 executive director: Dr. Matthias Baron register court Munich: HRB107092 place of business: Munich VAT-No.: DE166182346 Diese Nachricht kann vertrauliche, nicht für die Veröffentlichung bestimmte und/oder rechtlich geschützte Informationen enthalten. Falls Sie nicht der beabsichtigte Empfänger sind, beachten Sie bitte, daß jegliche Veröffentlichung, Verbreitung oder Vervielfältigung dieser Nachricht strengstens untersagt ist. Sollten Sie diese Nachricht irrtümlich erhalten haben, informieren Sie bitte sofort den Absender durch Anruf oder Rücksendung der Nachricht und vernichten Sie diese. This communication may contain information that is legally privileged, confidential or exempt from disclosure. If you are not the intended recipient, please note that any dissemination, distribution, or copying of this communication is strictly prohibited. Anyone who receives this message in error should notify the sender immediately by telephone or by return e-mail and delete this communication entirely from his or her computer. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] Mailing List: http://jakarta.apache.org/site/mail2.html#poi The Apache Jakarta POI Project: http://jakarta.apache.org/poi/