setForceFormulaRecalculation-methods {XLConnect} | R Documentation |
Forcing Excel to recalculate formula values when opening a workbook
Description
This function controls a flag that forces Excel to recalculate formula values when a workbook is opened.
Usage
## S4 method for signature 'workbook,character'
setForceFormulaRecalculation(object,sheet,value)
## S4 method for signature 'workbook,numeric'
setForceFormulaRecalculation(object,sheet,value)
Arguments
object |
The |
sheet |
The name or index of the sheet for which to force formula recalculation.
If |
value |
|
Details
The arguments sheet
and value
are vectorized such
that multiple worksheets can be controlled with one method call.
Note
A typical use for this flag is forcing Excel into updating formulas
that reference cells affected by writeWorksheet
or writeNamedRegion
.
The exact behavior of Excel when the flag is set depends on version and file format.
Author(s)
Thomas Themel
Mirai Solutions GmbH https://mirai-solutions.ch
See Also
workbook
,
getForceFormulaRecalculation
Examples
## Not run:
# mtcars xlsx file from demoFiles subfolder of package XLConnect
demoExcelFile <- system.file("demoFiles/mtcars.xlsx", package = "XLConnect")
# Load workbook
wb <- loadWorkbook(demoExcelFile)
# Tell Excel to automatically recalculate formulas on sheet mtcars
setForceFormulaRecalculation(wb, sheet = "mtcars", TRUE)
# The same with a numerical sheet index
setForceFormulaRecalculation(wb, sheet = 1, TRUE)
## End(Not run)