setForceFormulaRecalculation-methods
From XLConnect v1.0.2
by Martin Studer
Forcing Excel to recalculate formula values when opening a workbook
This function controls a flag that forces Excel to recalculate formula values when a workbook is opened.
Usage
# S4 method for workbook,character
setForceFormulaRecalculation(object,sheet,value)
# S4 method for workbook,numeric
setForceFormulaRecalculation(object,sheet,value)
Arguments
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.
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)
# }
Community examples
Looks like there are no examples yet.