poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Julien Oster <julien.os...@terrasel.de>
Subject Class IterationRecord
Date Fri, 30 Mar 2007 10:58:38 GMT
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:julien.oster@terrasel.de
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: poi-dev-unsubscribe@jakarta.apache.org
Mailing List:    http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta POI Project: http://jakarta.apache.org/poi/


Mime
View raw message