Platforms to show: All Mac Windows Linux Cross-Platform

Back to XLFormatMBS class.

Previous items Next items

XLFormatMBS.BorderStyleThick = 5

Type Topic Plugin Version
const XL MBS XL Plugin 11.3
One of the border style constants.

thick

XLFormatMBS.BorderStyleThin = 1

Type Topic Plugin Version
const XL MBS XL Plugin 11.3
One of the border style constants.

thin

XLFormatMBS.FillPatternDiagcrosshatch = 9

Type Topic Plugin Version
const XL MBS XL Plugin 11.3
One of the fill pattern style constants.

XLFormatMBS.FillPatternDiagstripe = 8

Type Topic Plugin Version
const XL MBS XL Plugin 11.3
One of the fill pattern style constants.

XLFormatMBS.FillPatternGray12P5 = 17

Type Topic Plugin Version
const XL MBS XL Plugin 11.3
One of the fill pattern style constants.

XLFormatMBS.FillPatternGray25 = 4

Type Topic Plugin Version
const XL MBS XL Plugin 11.3
One of the fill pattern style constants.

XLFormatMBS.FillPatternGray50 = 2

Type Topic Plugin Version
const XL MBS XL Plugin 11.3
One of the fill pattern style constants.

XLFormatMBS.FillPatternGray6P25 = 18

Type Topic Plugin Version
const XL MBS XL Plugin 11.3
One of the fill pattern style constants.

XLFormatMBS.FillPatternGray75 = 3

Type Topic Plugin Version
const XL MBS XL Plugin 11.3
One of the fill pattern style constants.

XLFormatMBS.FillPatternHorstripe = 5

Type Topic Plugin Version
const XL MBS XL Plugin 11.3
One of the fill pattern style constants.

XLFormatMBS.FillPatternNone = 0

Type Topic Plugin Version
const XL MBS XL Plugin 11.3
One of the fill pattern style constants.

XLFormatMBS.FillPatternRevdiagstripe = 7

Type Topic Plugin Version
const XL MBS XL Plugin 11.3
One of the fill pattern style constants.

XLFormatMBS.FillPatternSolid = 1

Type Topic Plugin Version
const XL MBS XL Plugin 11.3
One of the fill pattern style constants.
Example 
// define a format for red fill
Dim redBackgroundFormat As XLFormatMBS = book.AddFormat
Dim c As Color = &cFF0000
// will give back numeric value of color for RGB mode or color index
Dim n As Integer = book.PackColor(c)
// we set forecolor of the pattern to fill background!
redBackgroundFormat.PatternForegroundColor = n
redBackgroundFormat.PatternBackgroundColor = n
redBackgroundFormat.FillPattern = XLFormatMBS.FillPatternSolid

Dim row As Integer = 5 // 6th row
Dim col As Integer = 1 // Column B
Dim value As Double = 123

Call sheet.WriteNumber row, col, value, redBackgroundFormat

XLFormatMBS.FillPatternThickdiagcrosshatch = 10

Type Topic Plugin Version
const XL MBS XL Plugin 11.3
One of the fill pattern style constants.

XLFormatMBS.FillPatternThindiagcrosshatch = 16

Type Topic Plugin Version
const XL MBS XL Plugin 11.3
One of the fill pattern style constants.

XLFormatMBS.FillPatternThindiagstripe = 14

Type Topic Plugin Version
const XL MBS XL Plugin 11.3
One of the fill pattern style constants.

XLFormatMBS.FillPatternThinhorcrosshatch = 15

Type Topic Plugin Version
const XL MBS XL Plugin 11.3
One of the fill pattern style constants.

XLFormatMBS.FillPatternThinhorstripe = 11

Type Topic Plugin Version
const XL MBS XL Plugin 11.3
One of the fill pattern style constants.

XLFormatMBS.FillPatternThinrevdiagstripe = 13

Type Topic Plugin Version
const XL MBS XL Plugin 11.3
One of the fill pattern style constants.

XLFormatMBS.FillPatternThinverstripe = 12

Type Topic Plugin Version
const XL MBS XL Plugin 11.3
One of the fill pattern style constants.

XLFormatMBS.FillPatternVerstripe = 6

Type Topic Plugin Version
const XL MBS XL Plugin 11.3
One of the fill pattern style constants.

XLFormatMBS.NumformatAccount = 41

Type Topic Plugin Version
const XL MBS XL Plugin 11.3
One of the number format constants.

account value: 5,000

XLFormatMBS.NumformatAccountcur = 42

Type Topic Plugin Version
const XL MBS XL Plugin 11.3
One of the number format constants.

account value with currency symbol: $5,000

XLFormatMBS.NumformatAccountD2 = 43

Type Topic Plugin Version
const XL MBS XL Plugin 11.3
One of the number format constants.

account value with decimal point: 5,000.00

XLFormatMBS.NumformatAccountD2Cur = 44

Type Topic Plugin Version
const XL MBS XL Plugin 11.3
One of the number format constants.

account value with currency symbol and decimal point: $5,000.00

XLFormatMBS.NumformatCurrencyD2Negbra = 7

Type Topic Plugin Version
const XL MBS XL Plugin 11.3
One of the number format constants.

monetary value with decimal point, negative in brackets: ($1000.00)

XLFormatMBS.NumformatCurrencyD2NegbraRed = 8

Type Topic Plugin Version
const XL MBS XL Plugin 11.3
One of the number format constants.

monetary value with decimal point, negative is red in brackets: ($1000.00)

XLFormatMBS.NumformatCurrencyNegbra = 5

Type Topic Plugin Version
const XL MBS XL Plugin 11.3
One of the number format constants.

monetary value, negative in brackets: (1000$)

XLFormatMBS.NumformatCurrencyNegbraRed = 6

Type Topic Plugin Version
const XL MBS XL Plugin 11.3
One of the number format constants.

monetary value, negative is red in brackets: (1000$)

XLFormatMBS.NumformatCustom000P0EPlus0 = 48

Type Topic Plugin Version
const XL MBS XL Plugin 11.3
One of the number format constants.

custom value: 15.2E+3

Previous items Next items

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


💬 Ask a question or report a problem
The biggest plugin in space...