Platforms to show: All Mac Windows Linux Cross-Platform

Back to XLFormatMBS class.

Fillpattern Style Constants

XLFormatMBS.FillPatternDiagcrosshatch = 9

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

Diagonal cross hatch

XLFormatMBS.FillPatternDiagstripe = 8

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

Diagonal stripes

XLFormatMBS.FillPatternGray12P5 = 17

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

Gray dots

XLFormatMBS.FillPatternGray25 = 4

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

25% Gray

XLFormatMBS.FillPatternGray50 = 2

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

50% Gray

XLFormatMBS.FillPatternGray6P25 = 18

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

More gray dots

XLFormatMBS.FillPatternGray75 = 3

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

75% Gray

XLFormatMBS.FillPatternHorstripe = 5

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

Horizontal stripes

XLFormatMBS.FillPatternNone = 0

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

No filling

XLFormatMBS.FillPatternRevdiagstripe = 7

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

Reverse diagonal stripes

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

Solid fill

XLFormatMBS.FillPatternThickdiagcrosshatch = 10

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

Thick diagonal cross hatch

XLFormatMBS.FillPatternThindiagcrosshatch = 16

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

Thin diagonal cross hatch

XLFormatMBS.FillPatternThindiagstripe = 14

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

Thin diagonal stripes

XLFormatMBS.FillPatternThinhorcrosshatch = 15

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

Thin horizontal cross hatch

XLFormatMBS.FillPatternThinhorstripe = 11

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

Thin horizontal stripes

XLFormatMBS.FillPatternThinrevdiagstripe = 13

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

Thin vertical diagonal stripes

XLFormatMBS.FillPatternThinverstripe = 12

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

Thin vertical stripes

XLFormatMBS.FillPatternVerstripe = 6

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

Vertical stripes

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


The biggest plugin in space...