Platforms to show: All Mac Windows Linux Cross-Platform
Back to XLFormatMBS class.
Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
property | XL | MBS XL Plugin | 11.3 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
See AlignH* constants.
(Read and Write property)
Some examples using this property:
Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
property | XL | MBS XL Plugin | 11.3 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
See AlignV* constants.
(Read and Write property)
Some examples using this property:
Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
property | XL | MBS XL Plugin | 11.3 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
As a format is only valid with the owning book, we keep a back reference here.
(Read only property)
XLFormatMBS.BorderBottom as Integer
Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
property | XL | MBS XL Plugin | 11.3 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
See BorderStyle* constants.
(Read and Write property)
XLFormatMBS.BorderBottomColor as Integer
Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
property | XL | MBS XL Plugin | 11.3 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
If book is in RGB mode, you need to use UnpackColor to get red, green and blue color components or color value from the returned number. If book is not in RGB mode, you receive a color number (see XLFontMBS color constants).
If you set value and book is in RGB mode you can use PackColor function to get a numeric value for a color or color components. If the book is not in RGB mode, you can use color constants in XLFontMBS classes.
(Read and Write property)
XLFormatMBS.BorderDiagonal as Integer
Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
property | XL | MBS XL Plugin | 11.3 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
see BorderDiagonal* constants.
(Read and Write property)
XLFormatMBS.BorderDiagonalColor as Integer
Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
property | XL | MBS XL Plugin | 11.3 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
If book is in RGB mode, you need to use UnpackColor to get red, green and blue color components or color value from the returned number. If book is not in RGB mode, you receive a color number (see XLFontMBS color constants).
If you set value and book is in RGB mode you can use PackColor function to get a numeric value for a color or color components. If the book is not in RGB mode, you can use color constants in XLFontMBS classes.
(Read and Write property)
XLFormatMBS.BorderDiagonalStyle as Integer
Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
property | XL | MBS XL Plugin | 11.3 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
See BorderDiagonal* constants.
(Read and Write property)
XLFormatMBS.BorderLeft as Integer
Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
property | XL | MBS XL Plugin | 11.3 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
See BorderStyle* constants.
(Read and Write property)
XLFormatMBS.BorderLeftColor as Integer
Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
property | XL | MBS XL Plugin | 11.3 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
If book is in RGB mode, you need to use UnpackColor to get red, green and blue color components or color value from the returned number. If book is not in RGB mode, you receive a color number (see XLFontMBS color constants).
If you set value and book is in RGB mode you can use PackColor function to get a numeric value for a color or color components. If the book is not in RGB mode, you can use color constants in XLFontMBS classes.
(Read and Write property)
XLFormatMBS.BorderRight as Integer
Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
property | XL | MBS XL Plugin | 11.3 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
See BorderStyle* constants.
(Read and Write property)
XLFormatMBS.BorderRightColor as Integer
Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
property | XL | MBS XL Plugin | 11.3 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
If book is in RGB mode, you need to use UnpackColor to get red, green and blue color components or color value from the returned number. If book is not in RGB mode, you receive a color number (see XLFontMBS color constants).If you set value and book is in RGB mode you can use PackColor function to get a numeric value for a color or color components. If the book is not in RGB mode, you can use color constants in XLFontMBS classes.
(Read and Write property)
XLFormatMBS.BorderTop as Integer
Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
property | XL | MBS XL Plugin | 11.3 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
See BorderStyle* constants.
(Read and Write property)
XLFormatMBS.BorderTopColor as Integer
Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
property | XL | MBS XL Plugin | 11.3 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
If book is in RGB mode, you need to use UnpackColor to get red, green and blue color components or color value from the returned number. If book is not in RGB mode, you receive a color number (see XLFontMBS color constants).
If you set value and book is in RGB mode you can use PackColor function to get a numeric value for a color or color components. If the book is not in RGB mode, you can use color constants in XLFontMBS classes.
(Read and Write property)
XLFormatMBS.FillPattern as Integer
Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
property | XL | MBS XL Plugin | 11.3 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
See fill pattern constants.
(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 |
To create a new font use XLBookMBS.addFont(). Returns false if error occurs. Get error info with XLBookMBS.ErrorMessage property.
(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 |
(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 |
Must be less than or equal to 15.
(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 |
Needs to be used together with XLSheetMBS.Protect property and XLSheetMBS.SetProtectEx method to prevent editing in locked cells.
(Read and Write property)
XLFormatMBS.NumFormat as Integer
Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
property | XL | MBS XL Plugin | 11.3 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
The identifier must be a valid built-in number format identifier or the identifier of a custom number format. To create a custom format use XLBookMBS.addCustomNumFormat(). Or use one of the NumFormat* constants.
(Read and Write property)
XLFormatMBS.PatternBackgroundColor as Integer
Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
property | XL | MBS XL Plugin | 11.3 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
If book is in RGB mode, you need to use UnpackColor to get red, green and blue color components or color value from the returned number. If book is not in RGB mode, you receive a color number (see XLFontMBS color constants).
If you set value and book is in RGB mode you can use PackColor function to get a numeric value for a color or color components. If the book is not in RGB mode, you can use color constants in XLFontMBS classes.
(Read and Write property)
XLFormatMBS.PatternForegroundColor as Integer
Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
property | XL | MBS XL Plugin | 11.3 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
If book is in RGB mode, you need to use UnpackColor to get red, green and blue color components or color value from the returned number. If book is not in RGB mode, you receive a color number (see XLFontMBS color constants).
If you set value and book is in RGB mode you can use PackColor function to get a numeric value for a color or color components. If the book is not in RGB mode, you can use color constants in XLFontMBS classes.
(Read and Write property)
XLFormatMBS.Rotation as Integer
Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
property | XL | MBS XL Plugin | 11.3 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
Must be a value from the following table:
Value | Meaning |
0 - 90 | Text rotated counterclockwise 0 to 90 degrees |
91 - 180 | Text rotated clockwise 1 to 90 degrees |
255 | Vertical text |
XLFormatMBS.ShrinkToFit as boolean
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 |
(Read and Write property)
The items on this page are in the following plugins: MBS XL Plugin.
