officefileapi-devexpress-dot-spreadsheet-dot-spreadsheetfont-9bee73ae.md
Gets or sets the name of the font applied to cell content.
Namespace : DevExpress.Spreadsheet
Assembly : DevExpress.Spreadsheet.v25.2.Core.dll
NuGet Package : DevExpress.Spreadsheet.Core
string Name { get; set; }
Property Name As String
| Type | Description |
|---|---|
| String |
The font name.
|
Use the SpreadsheetFont object properties to specify font characteristics (Color, FontStyle, Size, Script, and so on). Use the Formatting.Font property to access this object.
See the following topics for examples on how to format a cell or cell range, and create or modify a cell style:
The Spreadsheet also allows you to use fonts that are not installed on the current operating system. Refer to this help topic for details: Load and Use Custom Fonts Without Installation on the System.
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;
' Access the Font object.
Dim cellFont As SpreadsheetFont = 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
The following code snippets (auto-collected from DevExpress Examples) contain references to the Name property.
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.
// Set the font name.
cellFont.Name = "Times New Roman";
// Set the font size.
winforms-spreadsheet-custom-draw-example/CS/WindowsFormsApp1/Form1.cs#L144
SpreadsheetFont defaultFont = spreadsheetControl1.Document.Styles.DefaultStyle.Font;
using (Font font = new Font(defaultFont.Name, (float)defaultFont.Size, FontStyle.Bold))
{
// Set the font name.
cellFont.Name = "Times New Roman";
// Set the font size.
// Specify the font name.
cellFont.Name = "Times New Roman";
// Specify the font size.
' Specify font settings (font name, color, size and style).
cell.Font.Name = "MV Boli"
cell.Font.Color = Color.Blue
' Set the font name.
cellFont.Name = "Times New Roman"
' Set the font size.
winforms-spreadsheet-custom-draw-example/VB/CustomDrawExample/Form1.vb#L42
Dim defaultFont As SpreadsheetFont = spreadsheetControl1.Document.Styles.DefaultStyle.Font
Using font As New Font(defaultFont.Name, CSng(defaultFont.Size), FontStyle.Bold)
' Specify layout settings for the column header.
' Set the font name.
cellFont.Name = "Times New Roman"
' Set the font size.
See Also