Skip to content

RewriteFormula

type RewriteFormula = (formula, formulaSheet, formulaWorkbook) => string;

A formula-rewriting transform, returned by structural-edit methods on Workbook (move/delete/insert) so the caller can apply it to other workbooks whose formulas may reference the affected region.

formulaSheet and formulaWorkbook are the names of the sheet and workbook containing the formula being rewritten --- needed to attribute unprefixed refs to the right workbook/sheet rather than the one where the edit ran. Workbook.rewriteFormulas supplies them automatically; direct callers must.

string

string

string

string