You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@poi.apache.org by bu...@apache.org on 2011/06/27 17:55:44 UTC

DO NOT REPLY [Bug 51422] Support using RecalcIdRecord to trigger a full formula recalculation on load

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

Yegor Kozlov <ye...@dinom.ru> changed:

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

--- Comment #1 from Yegor Kozlov <ye...@dinom.ru> 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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org