Skip to main content
.NET Framework 4.5.2+

Fill Interface

Contains the cell background attributes.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v23.1.Core.dll


public interface Fill


The Fill object provides a set of properties that you can use to customize the cell background. The Fill.BackgroundColor property specifies the cell background color (it is also available via the CellRange.FillColor property of the cell or cell range object), the Fill.PatternType specifies the type of cell background pattern (the PatternType enumeration lists the available pattern types) and the Fill.PatternColor specifies the shade color for a cell.

The Fill.FillType property specifies whether a gradient effect is applied to the cell background. The Fill.Gradient property contains gradient settings. Note that if the Fill.BackgroundColor property is set to a non-empty value, gradient effects are not applicable.

To access the Fill object, use the Formatting.Fill property.

For examples on how to specify formatting for an individual cell and cell range or modify a style, refer to the How to: Format a Cell or Range of Cells or How to: Create or Modify a Style document.

To custom paint a cell background in the SpreadsheetControl, handle the SpreadsheetControl.CustomDrawCellBackground event.


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;
See Also