.NET Framework 4.5.2+
.NET Framework 4.5.2+
.NET Standard 2.0+
A newer version of this page is available. Switch to the current version.

Fill Interface

Contains the cell background attributes.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v19.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 Range.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.


This example demonstrates how to format color characteristics (font and background colors) for an individual cell and range of cells.

// Format an individual cell.
worksheet.Cells["A1"].Font.Color = Color.Red;
worksheet.Cells["A1"].FillColor = Color.Yellow;

// Format a range of cells.
Range 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