xlsRecalculateAll (Function)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

Help / WLanguage / WLanguage functions / Standard functions / XLS file functions

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

xlsRecalculateAll (Function)

In french: xlsRecalculeTout

Recalculates all formulas in an Excel (XLSX) document.

New in version SaaS

This function is now available for Android applications.

This function is now available in Android widget mode.

This function is now available for iPhone/iPad applications.

Example

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 in a workbook that uses a formula.
This function cannot be used on an XLS document.

Component: wd300xls.dll