Platforms to show: All Mac Windows Linux Cross-Platform
XLFormatMBS class
Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
class | XL | MBS XL Plugin | 11.3 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
This is an abstract class. You can't create an instance, but you can get one from various plugin functions.
- 26 properties
- property AlignH as Integer
- property AlignV as Integer
- property Book as XLBookMBS
- property BorderBottom as Integer
- property BorderBottomColor as Integer
- property BorderDiagonal as Integer
- property BorderDiagonalColor as Integer
- property BorderDiagonalStyle as Integer
- property BorderLeft as Integer
- property BorderLeftColor as Integer
- property BorderRight as Integer
- property BorderRightColor as Integer
- property BorderTop as Integer
- property BorderTopColor as Integer
- property FillPattern as Integer
- property Font as XLFontMBS
- property Handle as Integer
- property Hidden as boolean
- property Indent as Integer
- property Locked as boolean
- property NumFormat as Integer
- property PatternBackgroundColor as Integer
- property PatternForegroundColor as Integer
- property Rotation as Integer
- property ShrinkToFit as boolean
- property Wrap as boolean
- 5 methods
- method Constructor Private
- method SetBorder(border as Integer = 1)
- method SetBorderColor(ColorValue as Integer)
- method SetFont(font as XLFontMBS) as boolean
- method SetRotation(rotation as Integer) as boolean
- 86 constants
This class has no sub classes.
Some methods using this class:
- XLBookMBS.AddFormat(initFormat as XLFormatMBS = nil) as XLFormatMBS
- XLBookMBS.Format(index as Integer) as XLFormatMBS
- XLSheetMBS.ReadDate(row as Integer, col as Integer, byref format as XLFormatMBS) as date
- XLSheetMBS.ReadNumber(row as Integer, col as Integer, byref format as XLFormatMBS) as Double
- XLSheetMBS.ReadRichString(row as integer, col as integer, byref format as XLFormatMBS) as XLRichStringMBS
- XLSheetMBS.SetRow(row as Integer, height as Double, format as XLFormatMBS = nil, hidden as boolean = false) as boolean
- XLSheetMBS.WriteDateTime(row as integer, col as integer, value as dateTime, format as XLFormatMBS = nil) as boolean
- XLSheetMBS.WriteFormulaBool(row as Integer, col as Integer, Expression as string, value as Boolean, format as XLFormatMBS = nil) as boolean
- XLSheetMBS.WriteString(row as Integer, col as Integer, value as string, format as XLFormatMBS = nil) as boolean
- XLSheetMBS.WriteStyledText(row as integer, col as integer, StyledText as StyledText, format as XLFormatMBS = nil) as boolean
Some properties using for this class:
- XLSheetMBS.CellFormat(row as Integer, col as Integer) as XLFormatMBS
Some examples using this class:
Blog Entries
Xojo Developer Magazine
Release notes
- 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.