CalculationSettings | @sheetwrite/core

Workbook calculation options, mirroring Excel's "Enable iterative calculation". A workbook without this record uses the defaults.

Members 3

iterate Recalculate circular references iteratively instead of showing #CYCLE!; Excel default false.

iterate: boolean;

maxIterations Most passes over each circular reference; an integer from 1 to 32,767, Excel default 100.

maxIterations: number;

maxChange Iteration stops once no value changes by more than this; finite and >= 0, Excel default 0.001.

maxChange: number;

View full TypeScript declaration

export interface CalculationSettings {
  iterate: boolean;
  maxIterations: number;
  maxChange: number;
}

Workspace packages depending on @sheetwrite/core

Public exports naming CalculationSettings

Loading documentation…