Formatting.Fill Property
Provides access to cell background.
Namespace: DevExpress.Spreadsheet
Assembly: DevExpress.Spreadsheet.v23.2.Core.dll
NuGet Package: DevExpress.Spreadsheet.Core
Declaration
Property Value
| Type | Description |
|---|---|
| Fill | A Fill object providing properties to change cell background characteristics. |
Remarks
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).
- To specify the background of an individual cell, use the Cell object’s Fill property that is inherited form the Formatting interface.
- To specify the background of a range of cells, call the CellRange.BeginUpdateFormatting method for this range, set the Fill property of the returned Formatting object and call the CellRange.EndUpdateFormatting method to finalize the modification.
- To share the same background settings between multiple cells in a single step, create or modify the style with the Fill property specified as required, and assign this style to CellRange.Style for the desired cells.
Example
The following example specifies font and background colors for an individual cell and cell range:
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);
Related GitHub Examples
The following code snippet (auto-collected from DevExpress Examples) contains a reference 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.