Platforms to show: All Mac Windows Linux Cross-Platform
Back to XLBookMBS class.
XLBookMBS.ActiveSheet as Integer
Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
property | XL | MBS XL Plugin | 11.3 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
(Read and Write property)
XLBookMBS.BiffVersion as Integer
Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
property | XL | MBS XL Plugin | 11.3 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
Used for xls format only.
(Read only property)
Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
property | XL | MBS XL Plugin | 20.2 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
Cal be manual, auto or automatic except for data tables.
See CalcMode* constants.
(Read and Write property)
XLBookMBS.ErrorMessage as string
Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
Property | XL | MBS XL Plugin | 11.3 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
(Read only property)
Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
property | XL | MBS XL Plugin | 11.3 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
(Read only property)
XLBookMBS.IsDate1904 as boolean
Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
property | XL | MBS XL Plugin | 13.2 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
A boolean value that indicates whether the date systems used in the workbook starts in 1904.
True indicates the date system starts in 1904, where January 1, 1904 is the first day in the system.
False indicates the workbook uses the 1900 date system, where January 1, 1900 is the first day in the system.
(Read and Write property)
XLBookMBS.IsTemplate as boolean
Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
property | XL | MBS XL Plugin | 14.0 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
The template flag: true - workbook is template, false - workbook is not template (default).
This flag must have a value "true" for template files (xlt and xltx).
(Read and Write property)
XLBookMBS.IsWriteProtected as Boolean
Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
property | XL | MBS XL Plugin | 23.1 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
(Read only property)
Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
property | XL | MBS XL Plugin | 11.3 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
(Read and Write property)
Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
property | XL | MBS XL Plugin | 11.3 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
true - RGB mode, false - Index mode (default).
In RGB mode use PackColor() and UnpackColor() methods for getting/setting colors. Used for xlsx format only.
(Read and Write property)
Some examples using this property:
The items on this page are in the following plugins: MBS XL Plugin.