Fill pattern styles used for ExcelFillPattern.PatternStyle.

Namespace: GemBox.Spreadsheet
Assembly: GemBox.Spreadsheet (in GemBox.Spreadsheet.dll) Version: 35.0.30.1025

Syntax

C#
public enum FillPatternStyle
Visual Basic
Public Enumeration FillPatternStyle

Members

Member nameValueDescription
None0 No fill pattern.
Solid1 "Solid" fill pattern using foreground color.
Gray618 "6% Gray" is Microsoft Excel pattern name, but any color can be used instead of black as a foreground color.
Gray1217 "12% Gray" is Microsoft Excel pattern name, but any color can be used instead of black as a foreground color.
Gray254 "25% Gray" is Microsoft Excel pattern name, but any color can be used instead of black as a foreground color.
Gray502 "50% Gray" is Microsoft Excel pattern name, but any color can be used instead of black as a foreground color.
Gray753 "75% Gray" is Microsoft Excel pattern name, but any color can be used instead of black as a foreground color.
HorizontalStripe5 "Horizontal Stripe" pattern.
VerticalStripe6 "Vertical Stripe" pattern.
DiagonalStripe8 "Diagonal Stripe" pattern.
ReverseDiagonalStripe7 "Reverse Diagonal Stripe" pattern.
DiagonalCrosshatch9 "Diagonal Crosshatch" pattern.
ThickDiagonalCrosshatch10 "Thick Diagonal Crosshatch" pattern.
ThinHorizontalStripe11 "Thin Horizontal Stripe" pattern.
ThinVerticalStripe12 "Thin Vertical Stripe" pattern.
ThinDiagonalStripe14 "Thin Diagonal Stripe" pattern.
ThinReverseDiagonalStripe13 "Thin Reverse Diagonal Stripe" pattern.
ThinHorizontalCrosshatch15 "Thin Horizontal Crosshatch" pattern.
ThinDiagonalCrosshatch16 "Thin Diagonal Crosshatch" pattern.

Remarks

To see names of Microsoft Excel patterns, start Microsoft Excel and go to "Format" menu > "Cells..." submenu > "Patterns" tab > "Pattern" drop-down. When hovering over a pattern, Microsoft Excel name is displayed in tooltip text.

None fill pattern uses no colors.

Solid fill pattern uses ExcelFillPattern.PatternForegroundColor.

All other paterns use both ExcelFillPattern.PatternForegroundColor and ExcelFillPattern.PatternBackgroundColor

See Also