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

Formatting.Font Property

Provides access to the cell font.

Namespace: DevExpress.Spreadsheet

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

Declaration

SpreadsheetFont Font { get; }
ReadOnly Property Font As SpreadsheetFont
SpreadsheetFont Font { get; }
ReadOnly Property Font As SpreadsheetFont
SpreadsheetFont Font { get; }
ReadOnly Property Font As SpreadsheetFont

Property Value

Type Description
SpreadsheetFont

A SpreadsheetFont object providing properties to change cell font attributes.

Property Value

Type Description
SpreadsheetFont

A SpreadsheetFont object providing properties to change cell font attributes.

Property Value

Type Description
SpreadsheetFont

A SpreadsheetFont object providing properties to change cell font attributes.

Remarks

For details on how to set different characteristics of a cell font, see the How to: Configure Cell Font Settings example.

Examples

This example demonstrates how to format cells in a worksheet.

// Access the cell to be formatted.
Cell cell = worksheet.Cells["B2"];

// Specify font settings (font name, color, size and style).
cell.Font.Name = "MV Boli";
cell.Font.Color = Color.Blue;
cell.Font.Size = 14;
cell.Font.FontStyle = SpreadsheetFontStyle.Bold;

// Specify cell background color.
cell.Fill.BackgroundColor = Color.LightSkyBlue;

// Specify text alignment in the cell. 
cell.Alignment.Vertical = SpreadsheetVerticalAlignment.Center;
cell.Alignment.Horizontal = SpreadsheetHorizontalAlignment.Center;
// Access the range of cells to be formatted.
CellRange range = worksheet.Range["C3:E6"];

// Begin updating of the range formatting. 
Formatting rangeFormatting = range.BeginUpdateFormatting();

// Specify font settings (font name, color, size and style).
rangeFormatting.Font.Name = "MV Boli";
rangeFormatting.Font.Color = Color.Blue;
rangeFormatting.Font.Size = 14;
rangeFormatting.Font.FontStyle = SpreadsheetFontStyle.Bold;

// Specify cell background color.
rangeFormatting.Fill.BackgroundColor = Color.LightSkyBlue;

// Specify text alignment in cells.
rangeFormatting.Alignment.Vertical = SpreadsheetVerticalAlignment.Center;
rangeFormatting.Alignment.Horizontal = SpreadsheetHorizontalAlignment.Center;

// End updating of the range formatting.
range.EndUpdateFormatting(rangeFormatting);
See Also