.NET Framework 4.5.2+
.NET Framework 4.5.2+
.NET Standard 2.0+
Row

Fill Interface

Contains the cell background attributes.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v21.2.Core.dll

Declaration

public interface Fill

Remarks

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.

Example

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);

The following code snippets (auto-collected from DevExpress Examples) contain references to the Fill interface.

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.

See Also