Excel.Interfaces.IterativeCalculationLoadOptions interface
Represents the iterative calculation settings.
Remarks
Properties
$all | Specifying |
enabled | True if Excel will use iteration to resolve circular references. |
max |
Specifies the maximum amount of change between each iteration as Excel resolves circular references. |
max |
Specifies the maximum number of iterations that Excel can use to resolve a circular reference. |
Property Details
$all
Specifying $all
for the LoadOptions loads all the scalar properties (e.g.: Range.address
) but not the navigational properties (e.g.: Range.format.fill.color
).
$all?: boolean;
Property Value
boolean
enabled
True if Excel will use iteration to resolve circular references.
enabled?: boolean;
Property Value
boolean
Remarks
maxChange
Specifies the maximum amount of change between each iteration as Excel resolves circular references.
maxChange?: boolean;
Property Value
boolean
Remarks
maxIteration
Specifies the maximum number of iterations that Excel can use to resolve a circular reference.
maxIteration?: boolean;
Property Value
boolean
Remarks
Office Add-ins
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for