XLBookMBS class constants

Online Documentation   -   Statistics   -   FAQ   -   Plugin Parts (All, Dependencies)   -   Class hierarchy

New in Version 22.2 22.3 22.4 22.5 23.0 23.1 23.2 23.3 23.4 23.5 24.0 24.1

The list of the   topics,   classes,   interfaces,   controls,   modules,   global methods by category,   global methods by name,   screenshots,   licenses   and   examples.

Platforms to show: All Mac Windows Linux Cross-Platform

XLBookMBS constants

Call Modes

Constant Value Description
CalcModeAuto 1 automatic calculation
CalcModeAutoNoTable 2 automatic except for data tables
CalcModeManual 0 manual calculation

Cell Styles

Constant Value Description
kCellstyle20Accent1 19
kCellstyle20Accent2 23
kCellstyle20Accent3 27
kCellstyle20Accent4 31
kCellstyle20Accent5 35
kCellstyle20Accent6 39
kCellstyle40Accent1 20
kCellstyle40Accent2 24
kCellstyle40Accent3 28
kCellstyle40Accent4 32
kCellstyle40Accent5 36
kCellstyle40Accent6 40
kCellstyle60Accent1 21
kCellstyle60Accent2 25
kCellstyle60Accent3 29
kCellstyle60Accent4 33
kCellstyle60Accent5 37
kCellstyle60Accent6 41
kCellstyleAccent1 22
kCellstyleAccent2, 26
kCellstyleAccent3 30
kCellstyleAccent4, 34
kCellstyleAccent5 38
kCellstyleAccent6, 42
kCellstyleBad 1 Bad, usually red text on a light red background.
kCellstyleCalc 4
kCellstyleCheckcell 5
kCellstyleComma 43 Comma
kCellstyleComma0 44 Comma [0]
kCellstyleCurrency 45 Currency
kCellstyleCurrency0 46 Currency [0]
kCellstyleExplanatory 6
kCellstyleGood 2
kCellstyleHeading1 14
kCellstyleHeading2 15
kCellstyleHeading3 16
kCellstyleHeading4 17
kCellstyleHyperlink 9
kCellstyleInput 7 Input field style
kCellstyleLinkedCell 10 Linked Cell style.
kCellstyleNeutral 3 Bad, usually brown text on a light orange background.
kCellstyleNormal 0 Normal.
kCellstyleNote 11 Note style
kCellstyleOutput, 8 Output field style
kCellstylePercent 47 Percent
kCellstyleTitle 13 Title style
kCellstyleTotal, 18 Total value style
kCellstyleWarning 12

Picture Format Constants

Constant Value Description
PictureTypeDIB 4 DIB format
PictureTypeEMF 5 EMF format
PictureTypeError &hFF Error. Check XLBookMBS.ErrorMessage method.
PictureTypeGIF 2 GIF format.
PictureTypeJPEG 1 JPEG format
PictureTypePICT 6 Mac PICT format.
PictureTypePNG 0 PNG format
PictureTypeTIFF 7 TIFF format
PictureTypeWMF 3 WMF format

Sheet Types

Constant Value Description
SheetTypeChart 1 Sheet is a chart.
SheetTypeSheet 0 This is a normal sheet.
SheetTypeUnknown 2 Type is unknown.

💬 Ask a question or report a problem