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