Skip to content

WriteOptions

Options for Model.write and Model.writeMultiple.

Writes are persistent edits (equivalent to Workbook.editCell); they have no transient mode that can be reverted. Capture a ValueSnapshot beforehand if you need to undo them.

optional forceRecalc?: boolean;

Recalculate every workbook even if no write occurred.


optional skipRecalc?: boolean;

Skip the automatic post-write recalculation.


optional skipVolatiles?: boolean;

Recalc with CHANGED_ONLY instead of CHANGED_OR_VOLATILE, leaving volatile cells alone.