XLConnect (version 1.1.0)

setForceFormulaRecalculation-methods: 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 workbook,character
setForceFormulaRecalculation(object,sheet,value)
# S4 method for workbook,numeric
setForceFormulaRecalculation(object,sheet,value)

Arguments

object

The workbook to use

sheet

The name or index of the sheet for which to force formula recalculation. If sheet = "*", the flag is set for all sheets in the workbook.

value

logical specifying if formula recalculation should be forced or not

Author

Thomas Themel
Mirai Solutions GmbH https://mirai-solutions.ch

Details

The arguments sheet and value are vectorized such that multiple worksheets can be controlled with one method call.

See Also

workbook, getForceFormulaRecalculation

Examples

if (FALSE) {
# 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)
}