Platforms to show: All Mac Windows Linux Cross-Platform

XLFontMBS class

dim book as XLBookMBS // your book
dim textFont as XLFontMBS = book.addFont()
textFont.size = 8
textFont.name = "Century Gothic"

• 11 properties
  • property Bold as Boolean
  • property Book as XLBookMBS
  • property ColorRGB as Color
  • property ColorValue as Integer
  • property Handle as Integer
  • property Italic as Boolean
  • property Name as string
  • property Script as Integer
  • property Size as Integer
  • property StrikeOut as Boolean
  • property Underline as Integer
• 2 methods
  • method Constructor   Private
  • method Operator_Compare(other as XLFontMBS) as Integer   New in 24.2
• 69 constants

This class has no sub classes.

Some methods using this class:

• XLBookMBS.AddFont(initFont as XLFontMBS = nil) as XLFontMBS
• XLBookMBS.Font(index as Integer) as XLFontMBS
• XLBookMBS.Fonts as XLFontMBS()
• XLFormatMBS.Operator_Compare(other as XLFontMBS) as Integer
• XLFormatMBS.SetFont(font as XLFontMBS) as boolean
• XLRichStringMBS.AddFont(templateFont as XLFontMBS = nil) as XLFontMBS
• XLRichStringMBS.AddText(text as String, font as XLFontMBS = nil)
• XLRichStringMBS.Text(Index as Integer, byref font as XLFontMBS) as String

Some properties using for this class:

• XLConditionalFormatMBS.Font as XLFontMBS
• XLFormatMBS.Font as XLFontMBS

Some examples using this class:

• /XL/Format
• /XL/Invoice
• /XL/Invoice xml
• /XL/Writing data

Blog Entries

• MBS Xojo Plugins, version 24.2pr1
• LibXL Extras for Xojo
• StyledText for Excel files with LibXL 3.9 in Xojo
• MBS Xojo Plugins, version 18.4pr9

Release notes

• Version 24.2
  • Added Operator_Compare method to XLFontMBS and XLFormatMBS classes.
  • Improved XLFontMBS and XLFormatMBS handling for our XL Plugin to cache the objects and reuse them.
• Version 18.4
  • Changed properties in XLAutoFilterMBS, XLBookMBS, XLFilterColumnMBS, XLFontMBS, XLFormatMBS and XLSheetMBS class to be visible in debugger.

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

XLFilterColumnMBS   -   XLFormatMBS