Excel.Interfaces.ApplicationUpdateData interface
An interface for updating data on the Application object, for use in application.set({ ... }).
Properties
| calculation |
Returns the calculation mode used in the workbook, as defined by the constants in |
| iterative |
Returns the iterative calculation settings. In Excel on Windows and Mac, the settings will apply to the Excel Application. In Excel on the web and other platforms, the settings will apply to the active workbook. |
Property Details
calculationMode
Returns the calculation mode used in the workbook, as defined by the constants in Excel.CalculationMode. Possible values are: Automatic, where Excel controls recalculation; AutomaticExceptTables, where Excel controls recalculation but ignores changes in tables; Manual, where calculation is done when the user requests it. This is a runtime property. The calculationMode setting is not persisted in the workbook.
calculationMode?: Excel.CalculationMode | "Automatic" | "AutomaticExceptTables" | "Manual";Property Value
Excel.CalculationMode | "Automatic" | "AutomaticExceptTables" | "Manual"
Remarks
iterativeCalculation
Returns the iterative calculation settings. In Excel on Windows and Mac, the settings will apply to the Excel Application. In Excel on the web and other platforms, the settings will apply to the active workbook.
iterativeCalculation?: Excel.Interfaces.IterativeCalculationUpdateData;