Note
Access to this page requires authorization. You can try signing in or .
Access to this page requires authorization. You can try .
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
Office Scripts
Feedback
Was this page helpful?