poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject DO NOT REPLY [Bug 51422] New: Support using RecalcIdRecord to trigger a full formula recalculation on load
Date Wed, 22 Jun 2011 21:20:29 GMT
https://issues.apache.org/bugzilla/show_bug.cgi?id=51422

             Bug #: 51422
           Summary: Support using RecalcIdRecord to trigger a full formula
                    recalculation on load
           Product: POI
           Version: 3.8-dev
          Platform: PC
        OS/Version: Linux
            Status: NEW
          Severity: normal
          Priority: P2
         Component: HSSF
        AssignedTo: dev@poi.apache.org
        ReportedBy: nick.burch@alfresco.com
    Classification: Unclassified


Just got this back from the Microsoft docs team:

In regards to your question about how to flag an .XLS file so that
all formula fields will be recalculated the next time it's opened by Excel,
there is not a record specifically for this purpose. However, there is one
that can be used to trigger certain behavior in Excel that will accomplish
the same results.

Please take a look at MS-XLS section
2.4.215<http://msdn.microsoft.com/en-us/library/dd909116(office.12).aspx>.
The dwBuildId value of the RecalcId record, when set to 0, will tell Excel
that it needs to recalculate all formulas in the workbook the next time the
file is opened. When the recalculation is complete, Excel will update
dwBuildId to the correct value and future recalculations will be performed
according to the Workbook Calculation settings.

It is not recommended to change the dwBuildId to a value other than what Excel
sets it to, or zero.


We currently have something on the sheet to request formula recalculation, 
setForceFormulaRecalculation(boolean), which apparently doesn't always work. We
should therefore probably add the recalcid trick in too

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


Mime
View raw message