Type Alias CalcProps

The calculation mode for the workbook.

• "auto" (default when absent): recalculate all formulas automatically.
• "autoNoTable": recalculate automatically but exclude data tables.
• "manual": formulas are only recalculated when explicitly triggered.

Which of the two date systems the workbook uses. 1900 is the default.

Whether the consuming application should perform a full recalculation when the workbook is opened.

Clients should set this when cached values may not reflect what the formulas would now yield, and clear it after a successful recalculation on load.

Full recalculation must be suppressed when CalcProps.calcMode is "manual" as the calcMode property takes precedence over this one.

Specifies whether an attempt should be made to calculate formulas that contain circular references. Defaults to false in Excel.

The maximum number of calculation iterations, when CalcProps.iterate is true. Defaults to 100 in Excel.

When a calculation iteration results in an absolute change that is less than iterateDelta, then no further iterations should be attempted. Defaults to 0.001 in Excel.