Excel.Interfaces.IterativeCalculationData interface

An interface describing the data returned by calling iterativeCalculation.toJSON().

Properties

enabled	True if Excel will use iteration to resolve circular references.
maxChange	Specifies the maximum amount of change between each iteration as Excel resolves circular references.
maxIteration	Specifies the maximum number of iterations that Excel can use to resolve a circular reference.

True if Excel will use iteration to resolve circular references.

enabled?: boolean;

boolean

Specifies the maximum amount of change between each iteration as Excel resolves circular references.

maxChange?: number;

number

Specifies the maximum number of iterations that Excel can use to resolve a circular reference.

maxIteration?: number;

number