ExcelScript.IterativeCalculation interface
Represents the iterative calculation settings.
Methods
| get |
True if Excel will use iteration to resolve circular references. |
| get |
Specifies the maximum amount of change between each iteration as Excel resolves circular references. |
| get |
Specifies the maximum number of iterations that Excel can use to resolve a circular reference. |
| set |
True if Excel will use iteration to resolve circular references. |
| set |
Specifies the maximum amount of change between each iteration as Excel resolves circular references. |
| set |
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