https://issues.apache.org/bugzilla/show_bug.cgi?id=45873
Josh Micich <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |RESOLVED Resolution| |WORKSFORME --- Comment #7 from Josh Micich <[email protected]> 2010-01-05 19:21:09 UTC --- Your example seems to work OK with poi-2.5.1-final-20040804, poi-3.1-FINAL-20080629, poi-3.2-FINAL, poi-3.5-beta5-20090115, poi-3.5-FINAL-20090928, poi-3.6-20091214 But with poi-3.0-FINAL and poi-3.0.2-FINAL-20080204, POI fails to encode the formula correctly (perhaps an old bug token operand class transformation). I'm a little surprised that you reported 3.0-rc4-20070503 to work for you. Perhaps your observations are specific to a particular Excel version. I use Win Excel 2007. It might be the case that prior versions of Excel don't auto-calculate a spreadsheet without being forced to. I don't recall if POI has changed recently (with regard to the default value of the auto-calculate flag). Try HSSFSheet.setForceFormulaRecalculation() to force Excel to re-calculate all formulas on the current sheet upon opening. On the other hand, you can use HSSFFormulaEvaluator and evaluateFormulaCell() to update the cached formula results so that re-calculation by Excel is not relevant. -- Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the assignee for the bug. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
