The requested page is not available for the requested platform. You are viewing the content for .NET Framework 4.5.2+ platform.
.NET Framework 4.5.2+
.NET Framework 4.5.2+
.NET Standard 2.0+
.NET Core 3.0+
Row

Fill.PatternColor Property

Gets or sets the cell shading color.

Namespace: DevExpress.Spreadsheet

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

Declaration

Color PatternColor { get; set; }
Property PatternColor As Color
Color PatternColor { get; set; }
Property PatternColor As Color
Color PatternColor { get; set; }
Property PatternColor As Color

Property Value

Type Description
Color

A Color value that is the cell shading color.

Property Value

Type Description
Color

A Color value that is the cell shading color.

Property Value

Type Description
Color

A Color value that is the cell shading color.

Remarks

To specify the cell background characteristics, use the Fill.BackgroundColor, Fill.PatternType and PatternColor properties of the Fill object.

Note that the PatternColor property influences a cell's appearance if the cell background pattern is other than PatternType.Solid or PatternType.None.

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

For examples on how to specify the format 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 specify the cell font color, use the SpreadsheetFont.Color property of the SpreadsheetFont object accessed via the Formatting.Font property. For details, review the How to: Change Cell Font and Background Color example.

Examples

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