Skip to content

getReplaceTableReferencesFn

getReplaceTableReferencesFn(): Promise<ReplaceTableReferencesFn>

Make a function that replaces table names in structured references in formulas in a syntactically sound way. That means: (a) it will only affect occurrences of the previous table name in structured references, and only in those structured references which have the given workbook name, or (if includeNoWb is true) have no workbook name. (c) it matches workbook names and table names case-insensitively.

This is an async factory for such a function because we need to dynamically import the waspiary module which is the actual implementation. The returned function is synchronous.

The returned function throws FormulaSyntaxError if the given formula is not parseable to begin with.

Promise<ReplaceTableReferencesFn>