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

SpreadsheetFont.Size Property

Gets or sets the size of the font applied to the cell content.

Namespace: DevExpress.Spreadsheet

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

Declaration

double Size { get; set; }

Property Value

Type Description
Double

A Double value specifying the font size in points.

Remarks

To specify all the required font characteristics, use the SpreadsheetFont object properties such as SpreadsheetFont.Name, SpreadsheetFont.FontStyle, SpreadsheetFont.Color, SpreadsheetFont.Script, etc. Access this object via the Formatting.Font 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, respectively.

To automatically reduce the font size to fit the cell content to the column width, use the Alignment.ShrinkToFit property. Note that this property does not change the Size property value.

Example

This example demonstrates how to format cell font characteristics (e.g., font name, size, color, style) by modifying the SpreadsheetFont object accessed via the Formatting.Font property of the Cell object.

// Access the Font object.
SpreadsheetFont cellFont = worksheet.Cells["A1"].Font;
// Set the font name.
cellFont.Name = "Times New Roman";
// Set the font size.
cellFont.Size = 14;
// Set the font color.
cellFont.Color = Color.Blue;
// Format text as bold.
cellFont.Bold = true;
// Set font to be underlined.
cellFont.UnderlineType = UnderlineType.Single;
See Also