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 Summary: Excel doesn't reevaluate formula cells, worked with 2.5.1 Product: POI Version: 3.0-dev Platform: All OS/Version: All Status: NEW Severity: blocker Priority: P2 Component: HSSF AssignedTo: poi-dev@jakarta.apache.org ReportedBy: [EMAIL PROTECTED] With POI 2.5.1, whenever you changed a cell on which a formula depended, that formula got reevaluated once you reopened the modified document in Excel. In 3.0 (both from the repository and the latest dev "release" from the download section), that doesn't seem to happy anymore. Simple Example: suppose you have the following Excel document: A1: somefoo A2: =A1 after modifying A1 with POI to contain 22 instead of "somefoo", A2 still shows "somefoo". This didn't happen with 2.5.1. Pressing F9 doesn't help, but one workaround I found: replace all occurences of '=' in the sheet with '='. Yes, it's the same character, but since it "touches" the formula cells, it forces Excel to reevaluate them (probably because Excel thinks you just changed them). So I'm actually contemplating to add a macro which does exactly that on load, for every sheet in the correct order, but that's a rather crude workaround. Maybe it's worth noting that I'm not using POI directly, but JXLS, which uses POI as backend. -- 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] Mailing List: http://jakarta.apache.org/site/mail2.html#poi The Apache Jakarta POI Project: http://jakarta.apache.org/poi/
