Xojo Conferences
MBSOct2019CologneDE

Platforms to show: All Mac Windows Linux Cross-Platform

XLFormatMBS.AlignH 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 horizontal alignment.
Notes:
See AlignH* constants.
(Read and Write property)

Feedback, Comments & Corrections

XLFormatMBS.AlignV 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 vertical alignment.
Notes:
See AlignV* constants.
(Read and Write property)

Feedback, Comments & Corrections

XLFormatMBS.BorderBottom 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 bottom border style.
Notes:
See BorderStyle* constants.
(Read and Write property)

Feedback, Comments & Corrections

XLFormatMBS.BorderBottomColor 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 color of the bottom border.
Notes:
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)

Feedback, Comments & Corrections

XLFormatMBS.BorderDiagonal 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 diagonal border.
Notes:
see BorderDiagonal* constants.
(Read and Write property)

Feedback, Comments & Corrections

XLFormatMBS.BorderDiagonalColor 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 color of the diagonal border.
Notes:
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)

Feedback, Comments & Corrections

XLFormatMBS.BorderDiagonalStyle 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 diagonal border style.
Notes:
See BorderDiagonal* constants.
(Read and Write property)

Feedback, Comments & Corrections

XLFormatMBS.BorderLeft 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 left border style.
Notes:
See BorderStyle* constants.
(Read and Write property)

Feedback, Comments & Corrections

XLFormatMBS.BorderLeftColor 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 color of the left border.
Notes:
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)

Feedback, Comments & Corrections

XLFormatMBS.BorderRight 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 right border style.
Notes:
See BorderStyle* constants.
(Read and Write property)

Feedback, Comments & Corrections

XLFormatMBS.BorderRightColor 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 color of the right border.
Notes:
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)

Feedback, Comments & Corrections

XLFormatMBS.BorderTop 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 top border style.
Notes:
See BorderStyle* constants.
(Read and Write property)

Feedback, Comments & Corrections

XLFormatMBS.BorderTopColor 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 color of the top border.
Notes:
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)

Feedback, Comments & Corrections

XLFormatMBS.FillPattern 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 fill pattern.
Notes:
See fill pattern constants.
(Read and Write property)

Feedback, Comments & Corrections

XLFormatMBS.Font as XLFontMBS
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
property XL MBS XL Plugin 11.3 Yes Yes Yes Yes No
Function: The font for the format.
Example:
// your book
dim book as XLBookMBS

// add font
dim StrikeOutFont as XLFontMBS = book.addFont()
StrikeOutFont.StrikeOut = true

// add format
dim StrikeOutFormat as XLFormatMBS = book.addFormat
StrikeOutFormat.font = StrikeOutFont

// write on a cell in first sheet
sheet = book.Sheet(0)
call sheet.WriteString(1, 1, "Sales Receipt", StrikeOutFormat)
Notes:
To create a new font use XLBookMBS.addFont(). Returns false if error occurs. Get error info with XLBookMBS.ErrorMessage property.
(Read and Write property)

Feedback, Comments & Corrections

XLFormatMBS.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

XLFormatMBS.Hidden 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 hidden protection property is set to true.
Notes: (Read and Write property)

Feedback, Comments & Corrections

XLFormatMBS.Indent 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 text indentation level.
Notes:
Must be less than or equal to 15.
(Read and Write property)

Feedback, Comments & Corrections

XLFormatMBS.Locked 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 locked protection property is set to true.
Notes: (Read and Write property)

Feedback, Comments & Corrections

XLFormatMBS.NumFormat 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 number format identifier.
Notes:
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)

Feedback, Comments & Corrections

XLFormatMBS.Owner as Variant
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
property XL MBS XL Plugin 11.3 Yes Yes Yes Yes No
Function: The object owning this format object.
Notes:
As a format is only valid with the owning book, we keep a back reference here.
(Read only property)

Feedback, Comments & Corrections

XLFormatMBS.PatternBackgroundColor 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 background color of the fill pattern.
Notes:
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)

Feedback, Comments & Corrections

XLFormatMBS.PatternForegroundColor 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 foreground color of the fill pattern.
Notes:
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)

Feedback, Comments & Corrections

XLFormatMBS.Rotation 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 the text rotation.
Notes:
Must be a value from the following table:
ValueMeaning
0 - 90Text rotated counterclockwise 0 to 90 degrees
91 - 180Text rotated clockwise 1 to 90 degrees
255Vertical text
(Read only property)

Feedback, Comments & Corrections

XLFormatMBS.ShrinkToFit 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 cell is shrink-to-fit.
Notes: (Read and Write property)

Feedback, Comments & Corrections

XLFormatMBS.Wrap 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 cell text is wrapped.
Notes: (Read and Write property)

Feedback, Comments & Corrections

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

The biggest plugin in space...




Links
MBS Xojo Chart Plugins