Platforms to show: All Mac Windows Linux Cross-Platform
Back to XLSheetMBS class.
XLSheetMBS.AutoFilter as XLAutoFilterMBS
Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
property | XL | MBS XL Plugin | 16.5 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
Creates it if it doesn't exist.
Only for xml based files.
(Read only property)
Some examples using this property:
Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
property | XL | MBS XL Plugin | 15.0 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
As a sheet is only valid with the owning book, we keep a back reference here.
(Read only property)
XLSheetMBS.DefaultRowHeight as Double
Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
property | XL | MBS XL Plugin | 23.1 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
(Read and Write property)
XLSheetMBS.DisplayGridlines as boolean
Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
property | XL | MBS XL Plugin | 11.3 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
True if gridlines are displayed and false if aren't.
(Assigning a value to this property calls setDisplayGridlines internally)
(Read and Write property)
Some examples using this property:
XLSheetMBS.FirstCol as Integer
Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
property | XL | MBS XL Plugin | 11.3 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
(Read only property)
Some examples using this property:
XLSheetMBS.FirstFilledCol as Integer
Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
property | XL | MBS XL Plugin | 20.3 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
(Read only property)
XLSheetMBS.FirstFilledRow as Integer
Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
property | XL | MBS XL Plugin | 20.3 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
(Read only property)
XLSheetMBS.FirstRow as Integer
Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
property | XL | MBS XL Plugin | 11.3 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
(Read only 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 |
The footer text appears at the bottom of every page when printed. The length of the text must be less than or equal to 255. The footer text can contain special commands, for example a placeholder for the page number, current date or text formatting attributes. Margin is specified in inches.
Code | Description |
&L | specifies the beginning of the left section |
&P | specifies the current page number |
&N | specifies the total number of pages |
&\d{1,3} | specifies the text font size, where font size is measured in points, for example: &9 or &36 |
&S | specifies whether the strikethrough text style is on or off |
&X | specifies whether the superscript text style is on or off |
&Y | specifies whether the subscript text style is on or off |
&C | specifies the beginning of the center section |
&D | specifies a date |
&T | specifies a time |
&G | specifies a picture |
&U | specifies whether the single underline text style is on or off |
&E | specifies whether the double underline text style is on or off |
&R | specifies the beginning of the right section |
&Z | specifies a workbook file path |
&F | specifies a workbook file name |
&A | specifies a sheet name |
&"fontname" | specifies the text font, for example: &"Comic Sans MS" |
&B | specifies whether the bold text style is on or off |
&I | specifies whether the italic text style is on or off |
&& | specifies an ampersand character (&) |
XLSheetMBS.FooterMargin as Double
Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
property | XL | MBS XL Plugin | 11.3 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
(Read only property)
XLSheetMBS.FormControlCount as Integer
Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
property | XL | MBS XL Plugin | 21.5 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
(Read only property)
XLSheetMBS.GetHorPageBreakCount as Integer
Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
property | XL | MBS XL Plugin | 11.3 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
(Read only property)
XLSheetMBS.GetVerPageBreakCount as Integer
Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
property | XL | MBS XL Plugin | 11.3 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
(Read only property)
XLSheetMBS.GroupSummaryBelow as boolean
Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
property | XL | MBS XL Plugin | 11.3 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
True if summary is below and false if isn't.
(Read and Write property)
XLSheetMBS.GroupSummaryRight as boolean
Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
property | XL | MBS XL Plugin | 11.3 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
Returns true if summary is right and false if isn't.
(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)
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 |
The text appears at the top of every page when printed. The length of the text must be less than or equal to 255. The header text can contain special commands, for example a placeholder for the page number, current date or text formatting attributes. Special commands are represented by single letter with a leading ampersand ("&"). Margin is specified in inches.
Code | Description |
&L | specifies the beginning of the left section |
&P | specifies the current page number |
&N | specifies the total number of pages |
&\d{1,3} | specifies the text font size, where font size is measured in points, for example: &9 or &36 |
&S | specifies whether the strikethrough text style is on or off |
&X | specifies whether the superscript text style is on or off |
&Y | specifies whether the subscript text style is on or off |
&C | specifies the beginning of the center section |
&D | specifies a date |
&T | specifies a time |
&G | specifies a picture |
&U | specifies whether the single underline text style is on or off |
&E | specifies whether the double underline text style is on or off |
&R | specifies the beginning of the right section |
&Z | specifies a workbook file path |
&F | specifies a workbook file name |
&A | specifies a sheet name |
&"fontname" | specifies the text font, for example: &"Comic Sans MS" |
&B | specifies whether the bold text style is on or off |
&I | specifies whether the italic text style is on or off |
&& | specifies an ampersand character (&) |
XLSheetMBS.HeaderMargin as Double
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 | 12.1 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
See constants: SheetStateHidden, SheetStateVeryHidden, SheetStateVisible.
(Read and Write property)
XLSheetMBS.HyperlinkSize as Integer
Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
property | XL | MBS XL Plugin | 14.3 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
(Read only property)
Some examples using this property:
XLSheetMBS.Landscape as boolean
Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
property | XL | MBS XL Plugin | 11.3 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
true - pages are printed using landscape mode, false - pages are printed using portrait mode.
(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)
Some examples using this property:
XLSheetMBS.LastFilledCol as Integer
Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
property | XL | MBS XL Plugin | 20.3 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
(Read only property)
XLSheetMBS.LastFilledRow as Integer
Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
property | XL | MBS XL Plugin | 20.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 only property)
Some examples using this property:
XLSheetMBS.MarginBottom as Double
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)
XLSheetMBS.MarginLeft as Double
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)
XLSheetMBS.MarginRight as Double
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)
XLSheetMBS.MarginTop as Double
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)
XLSheetMBS.MergeSize as Integer
Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
property | XL | MBS XL Plugin | 14.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)
XLSheetMBS.NamedRangeCount as Integer
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 |
See Paper* constants.
(Read and Write property)
XLSheetMBS.PictureCount as Integer
Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
property | XL | MBS XL Plugin | 11.3 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
(Read only property)
XLSheetMBS.PrintGridlines as boolean
Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
property | XL | MBS XL Plugin | 11.3 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
True if gridlines are printed and false if aren't.
(Read and Write property)
XLSheetMBS.PrintRowCol 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)
XLSheetMBS.PrintZoom as Integer
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)
XLSheetMBS.RightToLeft as boolean
Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
property | XL | MBS XL Plugin | 14.0 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
true - the text is displayed in right-to-left mode,
false - the text is displayed in left-to-right mode.
(Read and Write property)
XLSheetMBS.TabColor as Integer
Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
property | XL | MBS XL Plugin | 23.1 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
For use with documents using indexed colors.
(Read and Write property)
XLSheetMBS.TableSize as Integer
Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
property | XL | MBS XL Plugin | 16.5 | ✅ 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 |
100 is a usual view.
(Read and Write property)
The items on this page are in the following plugins: MBS XL Plugin.
