getForceFormulaRecalculation-methods

0th

Percentile

Querying the coordinates of the range reference by an Excel name

Queries the "force formula recalculation" flag on an Excel worksheet.

Keywords
methods, utilities
Usage
# S4 method for workbook,character
getForceFormulaRecalculation(object,sheet)
# S4 method for workbook,numeric
getForceFormulaRecalculation(object,sheet)
Arguments
object

The '>workbook to use

sheet

The name or index of the sheet to query. This argument is vectorized such that multiple sheets can be queried with one method call. If sheet = "*", the flag is queried for all sheets in the '>workbook (in the order as returned by getSheets).

See Also

'>workbook, getSheets, setForceFormulaRecalculation

Aliases
  • getForceFormulaRecalculation
  • getForceFormulaRecalculation-methods
  • getForceFormulaRecalculation,workbook,character-method
  • getForceFormulaRecalculation,workbook,numeric-method
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)

# Ask whether Excel will automatically recalculate formulas on sheet mtcars
print(getForceFormulaRecalculation(wb, sheet = "mtcars"))
# }
Documentation reproduced from package XLConnect, version 0.2-14, License: GPL-3

Community examples

Looks like there are no examples yet.