ExcelScript.IterativeCalculation interface

Package:

ExcelScript

Represents the iterative calculation settings.

Methods

getEnabled()	True if Excel will use iteration to resolve circular references.
getMaxChange()	Specifies the maximum amount of change between each iteration as Excel resolves circular references.
getMaxIteration()	Specifies the maximum number of iterations that Excel can use to resolve a circular reference.
setEnabled(enabled)	True if Excel will use iteration to resolve circular references.
setMaxChange(maxChange)	Specifies the maximum amount of change between each iteration as Excel resolves circular references.
setMaxIteration(maxIteration)	Specifies the maximum number of iterations that Excel can use to resolve a circular reference.

Method Details

getEnabled()

True if Excel will use iteration to resolve circular references.

getEnabled(): boolean;

Returns

boolean

getMaxChange()

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

getMaxChange(): number;

Returns

number

getMaxIteration()

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

getMaxIteration(): number;

Returns

number

setEnabled(enabled)

True if Excel will use iteration to resolve circular references.

setEnabled(enabled: boolean): void;

Parameters

enabled

boolean

Returns

void

setMaxChange(maxChange)

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

setMaxChange(maxChange: number): void;

Parameters

maxChange

number

Returns

void

setMaxIteration(maxIteration)

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

setMaxIteration(maxIteration: number): void;

Parameters

maxIteration

number

Returns

void