Edit

Share via

Excel.Interfaces.IterativeCalculationLoadOptions interface

  • Reference
Package:
excel

Warning

This API is now deprecated.

Represents the iterative calculation settings.

Remarks

[ API set: ExcelApi 1.9 ]

Properties

$all

Specifying $all for the load options loads all the scalar properties (such as Range.address) but not the navigational properties (such as Range.format.fill.color).
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.

Property Details

$all

Warning

This API is now deprecated.

Specifying $all for the load options loads all the scalar properties (such as Range.address) but not the navigational properties (such as Range.format.fill.color).

$all?: boolean;

Property Value

boolean

enabled

Warning

This API is now deprecated.

True if Excel will use iteration to resolve circular references.

enabled?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.9 ]

maxChange

Warning

This API is now deprecated.

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

maxChange?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.9 ]

maxIteration

Warning

This API is now deprecated.

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

maxIteration?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.9 ]