https://issues.apache.org/bugzilla/show_bug.cgi?id=51422

Yegor Kozlov <[email protected]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |RESOLVED
         Resolution|                            |FIXED

--- Comment #1 from Yegor Kozlov <[email protected]> 2011-06-27 15:55:44 UTC ---
Committed in r1140210

I added  Workbook.setForceFormulaRecalculation. Users are recommended to use it
instead of Sheet.setForceFormulaRecalculation. The latter works only on sheet
level and may not work if formulas refer to other sheets or external sources. 
I tested in Excel 2003 and 2010 and the recalcid trick always worked.

HSSF implements Workbook.setForceFormulaRecalculation via RecalcIdRecord. 
XSSF does it via CTCalcPr.calcId property which is direct counterpart of
RecalcId. 

I also added some notes about formula recalculation on
http://poi.apache.org/spreadsheet/eval.html

Yegor

-- 
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]

Reply via email to