|
|
|
|
|
|
|
|
xlsRecalculateAll (Function) In french: xlsRecalculeTout Recalculates all formulas in an Excel (XLSX) document.
MyDocument is xlsDocument
// Make changes to the XLSX document
MyDocument[1,"A"] = 1
// Define the formula
MyDocument[1,"B"].Formula = "A1"
// Recalculates all formulas
xlsRecalculateAll(MyDocument)
Syntax
xlsRecalculateAll(<Excel document>)
<Excel document>: xlsDocument variable Name of the xlsDocument variable used. Remarks - Changing the value or formula in a cell does not automatically recalculate the formulas in the workbook.
- xlsRecalculateAll must be called after changing the value or formula of one or more cells. It updates the values of the cells of the workbook that uses a formula.
- This function cannot be used on an XLS document.
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|