WriteOptions

Properties

forceRecalc?

optional forceRecalc?: boolean;

Recalculate all workbooks even if no writes were performed

Default

false

---

neutralizeFormulaOnSingleCellWrite?

optional neutralizeFormulaOnSingleCellWrite?: boolean;

When writing a value to a single formula cell, neutralize its formula until reset. (This applies to single-cell writes only; range writes always neutralize formulas.)

Default

false

---

reset?

optional reset?: boolean;

Reset any previous writes first (so only these writes apply)

Default

false

---

skipRecalc?

optional skipRecalc?: boolean;

Skip triggering recalculation (normally done automatically on write calls)

Default

false

---

skipVolatiles?

optional skipVolatiles?: boolean;

Skip volatile formula cells in setting up recalculation roots. (They may still be recalculation roots if they depend on a written cell, of course.)

Default

false