setForceFormulaRecalculation-methods | R Documentation |
This function controls a flag that forces Excel to recalculate formula values when a workbook is opened.
## S4 method for signature 'workbook,character' setForceFormulaRecalculation(object,sheet,value) ## S4 method for signature 'workbook,numeric' setForceFormulaRecalculation(object,sheet,value)
object |
The |
sheet |
The name or index of the sheet for which to force formula recalculation.
If |
value |
|
The arguments sheet
and value
are vectorized such
that multiple worksheets can be controlled with one method call.
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.
Thomas Themel
Mirai Solutions GmbH https://mirai-solutions.ch
workbook
,
getForceFormulaRecalculation
## 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)
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.