officefileapi-devexpress-dot-spreadsheet-dot-fill-0d043f5a.md
Gets or sets the fill type.
Namespace : DevExpress.Spreadsheet
Assembly : DevExpress.Spreadsheet.v25.2.Core.dll
NuGet Package : DevExpress.Spreadsheet.Core
FillType FillType { get; set; }
Property FillType As FillType
| Type | Description |
|---|---|
| FillType |
A FillType enumeration member. Default is Pattern.
|
Available values:
| Name | Description |
|---|---|
| Pattern |
The background is painted using a pattern.
| | Gradient |
The background is painted using a color gradient.
|
The FillType property specifies the fill type and the set of properties that will be used to fill the background.
If the FillType is set to the FillType.Gradient, the Fill.Gradient values will be used. If the FillType is set to the FillType.Pattern value, the background will be filled with a pattern whose settings are specified by the Fill.BackgroundColor, Fill.PatternType and Fill.PatternColor properties.
To access the Fill object, use the Formatting.Fill property.
The following code snippet (auto-collected from DevExpress Examples) contains a reference to the FillType property.
Note
The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.
Dim fillA1 As Fill = worksheet.Cells("A1").Fill
fillA1.FillType = FillType.Gradient
fillA1.Gradient.Type = GradientFillType.Linear
See Also