| Components | All | New | MacOS | Windows | Linux | iOS | ||||
| Examples | Mac & Win | Server | Client | Guides | Statistic | FMM | Blog | Deprecated | Old | |
XL.Book.SetCalcMode
Sets the current calculation mode.
| Component | Version | macOS | Windows | Linux | Server | iOS SDK |
| XL | 10.2 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes |
MBS( "XL.Book.SetCalcMode"; bookRef; Mode ) More
Parameters
| Parameter | Description | Example |
|---|---|---|
| bookRef | The reference to the workbook. Please use XL.LoadBook to load a file. | $ref |
| Mode | The new calculation mode. Can be 0 for manual, 1 for auto and 2 for auto without data tables. |
1 |
Result
Returns OK or error.
Description
Sets the current calculation mode.Can be 0 for manual, 1 for auto and 2 for auto without data tables.
Examples
Sets calculation mode to auto:
Set Variable [ $r ; Value: MBS( "XL.Book.SetCalcMode"; $bookRef; 1 ) ]
See also
Release notes
- Version 10.2
- Added XL.Book.GetCalcMode and XL.Book.SetCalcMode functions.
Blog Entries
This function checks for a license.
Created 18th April 2020, last changed 9th November 2021
