Formatting.Fill Property
Provides access to cell background.
Namespace: DevExpress.Spreadsheet
Assembly: DevExpress.Spreadsheet.v20.2.Core.dll
NuGet Package: DevExpress.Spreadsheet.Core
NuGet Packages: DevExpress.Spreadsheet.Core, DevExpress.WindowsDesktop.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);