Function adjustFormula

A formula after rows or columns were inserted or deleted, or cells moved (Excel's rules): references behind the edit move, a range grows when rows are inserted inside it and shrinks when some of its rows are deleted; a deleted reference (or a fully deleted range) becomes #REF!, as does one pushed off the sheet (a range ending at the last row stays there). moveCells: references and ranges completely inside the moved cells follow them. Formula text without =; unparsable text and formulas without a changed reference are returned unchanged (same spelling).

Example

adjustFormula("SUM(D2:D4)+B3", { kind: "deleteRows", at: 2, count: 1 });   // "SUM(D2:D3)+#REF!"
Copy

Since

1.1.99