[prev in list] [next in list] [prev in thread] [next in thread] 

List:       poi-dev
Subject:    DO NOT REPLY [Bug 41971]  - Excel doesn't reevaluate formula cells, worked with 2.5.1
From:       bugzilla () apache ! org
Date:       2007-03-30 10:58:21
Message-ID: 20070330105821.57F72714068 () brutus ! apache ! org
[Download RAW message or body]

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 julien.oster@terrasel.de  2007-03-30 03:58 -------
[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

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

[prev in list] [next in list] [prev in thread] [next in thread]