Xojo Conferences
XDCMay2019MiamiUSA

Platforms to show: All Mac Windows Linux Cross-Platform

XLBookMBS.ActiveSheet as Integer
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
property XL MBS XL Plugin 11.3 Yes Yes Yes Yes No
Function: Active sheet index in this workbook.
Notes: (Read and Write property)

Feedback, Comments & Corrections

XLBookMBS.BiffVersion as Integer
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
property XL MBS XL Plugin 11.3 Yes Yes Yes Yes No
Function: Returns BIFF version of binary file.
Notes:
Used for xls format only.
(Read only property)

Feedback, Comments & Corrections

XLBookMBS.ErrorMessage as string
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
Property XL MBS XL Plugin 11.3 Yes Yes Yes Yes No
Function: Returns the last error message.
Notes: (Read only property)

Feedback, Comments & Corrections

XLBookMBS.Handle as Integer
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
property XL MBS XL Plugin 11.3 Yes Yes Yes Yes No
Function: The internal object reference.
Notes: (Read and Write property)

Feedback, Comments & Corrections

XLBookMBS.IsDate1904 as boolean
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
property XL MBS XL Plugin 13.2 Yes Yes Yes Yes No
Function: Whether dates are 1904 based.
Notes:
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)

Feedback, Comments & Corrections

XLBookMBS.IsTemplate as boolean
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
property XL MBS XL Plugin 14.0 Yes Yes Yes Yes No
Function: Whether the workbook is template.
Notes:
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)

Feedback, Comments & Corrections

XLBookMBS.RefR1C1 as Integer
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
property XL MBS XL Plugin 11.3 Yes Yes Yes Yes No
Function: Whether the R1C1 reference mode is active.
Notes: (Read and Write property)

Feedback, Comments & Corrections

XLBookMBS.RgbMode as boolean
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
property XL MBS XL Plugin 11.3 Yes Yes Yes Yes No
Function: Whether the RGB mode is active. Used for xlsx format only.
Notes:
true - RGB mode, false - Index mode (default).
In RGB mode use colorPack() and colorUnpack() methods for getting/setting colors. Used for xlsx format only.
(Read and Write property)

Feedback, Comments & Corrections

The items on this page are in the following plugins: MBS XL Plugin.




Links
MBS FileMaker Plugins