ReplaceSheetReferencesFn
ReplaceSheetReferencesFn = (
formula,fromName,toName,workbookName,includeNoWb?) =>string
Rewrite the given formula, replacing references to a given sheet with a new sheet name.
Parameters
Section titled “Parameters”formula
Section titled “formula”string
formula to rewrite
fromName
Section titled “fromName”string
existing sheet name to match (case-insensitive)
toName
Section titled “toName”string
new sheet name to replace fromName with
workbookName
Section titled “workbookName”string
workbook name (case-insensitive) in which to replace sheet references; reference prefixes with a different workbook name will be left unchanged
includeNoWb?
Section titled “includeNoWb?”boolean
true to replace sheet name in reference prefixes that do not specify a workbook name
Returns
Section titled “Returns”string
Throws
Section titled “Throws”if formula fails to parse