ConstReadonlyAutomatic: "auto"ReadonlyAutomaticExceptTables: "automaticExceptTables"Calculates new formula results every time the relevant data is changed, unless the formula is in a data table.
ReadonlyManual: "manual"In manual calculation mode, the calculation engine does not automatically recalculate formulas when changes
are made. Instead, formulas are only recalculated when the user explicitly triggers a calculation
(e.g., by pressing F9 or calling calculate()).
This mode can improve performance in large workbooks where automatic recalculation would be too slow, but it
requires users to remember to manually recalculate to see updated results.
In automatic calculation mode, the calculation engine automatically recalculates all dependent formulas whenever a change is made to the workbook that affects their inputs. This is the default mode and ensures that all formula results are always up to date.