apps-script-utils 2.1.1 Help

FormulaTransformer

type FormulaTransformer = (formula: string, row: number, column: number) => string;

It receives the formula and the row and column it sits in, and returns the formula to put back. Returning the one it was given leaves the cell untouched, and updateFormulas writes only the cells that actually changed.

Examples

Shape

const rewrite = (formula, row, column) => formula.replace("Sheet1", "Data");

See also

Source

src/appsscript/sheet/updateFormulas.ts

23 September 2026

This documentation was generated with AI (Claude) from the library's source code.