officefileapi-devexpress-dot-spreadsheet-dot-formatting.md
Provides access to cell background.
Namespace : DevExpress.Spreadsheet
Assembly : DevExpress.Spreadsheet.v25.2.Core.dll
NuGet Package : DevExpress.Spreadsheet.Core
Fill Fill { get; }
ReadOnly Property Fill As Fill
| Type | Description |
|---|---|
| Fill |
A Fill object providing properties to change cell background characteristics.
|
Use properties of the Fill object to customize the cell background. For example, you can fill cells with solid colors (Fill.BackgroundColor, CellRange.FillColor), shade cells with patterns (Fill.PatternType, Fill.PatternColor) or apply gradient effect (Fill.Gradient).
The following example specifies font and background colors for an individual cell and cell range:
View Example: Spreadsheet Document API Examples
using DevExpress.Spreadsheet;
using System.Drawing;
// ...
// Format an individual cell.
worksheet.Cells["A1"].Font.Color = Color.Red;
worksheet.Cells["A1"].FillColor = Color.Yellow;
// Format a cell range.
CellRange range = worksheet.Range["C3:D4"];
Formatting rangeFormatting = range.BeginUpdateFormatting();
rangeFormatting.Font.Color = Color.Blue;
rangeFormatting.Fill.BackgroundColor = Color.LightBlue;
rangeFormatting.Fill.PatternType = PatternType.LightHorizontal;
rangeFormatting.Fill.PatternColor = Color.Violet;
range.EndUpdateFormatting(rangeFormatting);
Imports DevExpress.Spreadsheet
Imports System.Drawing
' ...
' Format an individual cell.
worksheet.Cells("A1").Font.Color = Color.Red
worksheet.Cells("A1").FillColor = Color.Yellow
' Format a cell range.
Dim range As CellRange = worksheet.Range("C3:D4")
Dim rangeFormatting As Formatting = range.BeginUpdateFormatting()
rangeFormatting.Font.Color = Color.Blue
rangeFormatting.Fill.BackgroundColor = Color.LightBlue
rangeFormatting.Fill.PatternType = PatternType.LightHorizontal
rangeFormatting.Fill.PatternColor = Color.Violet
range.EndUpdateFormatting(rangeFormatting)
The following code snippets (auto-collected from DevExpress Examples) contain references to the Fill 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.
CellRange range = worksheet.Range["A3:F22"];
worksheet.Sort(range, 0, worksheet["A3"].Fill);
CellRange range = worksheet.Range["A3:F22"];
worksheet.Sort(range, 0, worksheet["A3"].Fill);
CellRange range = worksheet.Range["A3:F22"];
worksheet.Sort(range, 0, worksheet["A3"].Fill);
Dim range As CellRange = worksheet.Range("A3:F22")
worksheet.Sort(range, 0, worksheet("A3").Fill)
' Specify a linear gradient fill for a cell.
Dim fillA1 As Fill = worksheet.Cells("A1").Fill
fillA1.FillType = FillType.Gradient
See Also