SpreadsheetFont.Name Property

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

Namespace: DevExpress.Spreadsheet

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

Declaration

C#

string Name { get; set; }

VB.NET

Property Name As String

Property Value

Type	Description
String	A String value specifying the font name.

Remarks

To specify all the required font characteristics, use the SpreadsheetFont object properties such as SpreadsheetFont.Color, SpreadsheetFont.FontStyle, SpreadsheetFont.Size, SpreadsheetFont.Script, etc. Access this object via the Formatting.Font property.

• To specify the font of an individual cell, access the SpreadsheetFont object using the cell’s Formatting.Font property directly.
• To specify the font of a cell range, modify the SpreadsheetFont object within the Range.BeginUpdateFormatting - Range.EndUpdateFormatting method pair.
• To share the same font settings between multiple cells in one step, apply the style with the specified font to the required cells. To specify the cell style font, access the Style object from the IWorkbook.Styles collection and use this style’s Formatting.Font property within the Formatting.BeginUpdate-Formatting.EndUpdate paired methods to access and modify the SpreadsheetFont object.

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, respectively.

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.

Note

A complete sample project is available at https://github.com/DevExpress-Examples/winforms-spreadsheetcontrol-api-e4655

FormattingActions.cs

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

FormattingActions.vb

' 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

Related GitHub Examples

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.

C#

how-to-display-a-custom-control-over-the-worksheet-cell-t208764/CS/SpreadsheetCustomization/Form1.cs#L88

    comboBox.ForeColor = font.Color;
    comboBox.Font = new Font(font.Name, (float)font.Size, GetFontStyle(font));
}

how-to-display-custom-controls-instead-of-the-standard-cell-editor-t259398/CS/SpreadsheetCustomization/Form1.cs#L172

    lookUpEdit.ForeColor = font.Color;
    lookUpEdit.Font = new Font(font.Name, (float)font.Size, GetFontStyle(font));
}

spreadsheet-document-api-examples-part1/CS/SpreadsheetExamples/SpreadsheetActions/FormattingActions.cs#L254

// Set the font name.
cellFont.Name = "Times New Roman";
// Set the font size.

VB.NET

how-to-display-a-custom-control-over-the-worksheet-cell-t208764/VB/SpreadsheetCustomization/Form1.vb#L80

    comboBox.ForeColor = font.Color
    comboBox.Font = New Font(font.Name, CSng(font.Size), GetFontStyle(font))
End Sub

how-to-display-custom-controls-instead-of-the-standard-cell-editor-t259398/VB/SpreadsheetCustomization/Form1.vb#L173

    lookUpEdit.ForeColor = font.Color
    lookUpEdit.Font = New Font(font.Name, CSng(font.Size), GetFontStyle(font))
End Sub

wpf-spreadsheetcontrol-api-part-1-e4938/VB/SpreadsheetControl_WPF_API/SpreadsheetActions/FormattingActions.vb#L350

' Set the font name.
cellFont.Name = "Times New Roman"
' Set the font size.

winforms-spreadsheetcontrol-api-e4655/VB/SpreadsheetControl/SpreadsheetActions/FormattingActions.vb#L382

' Set the font name.
cellFont.Name = "Times New Roman"
' Set the font size.

spreadsheet-document-api-examples-part1/VB/SpreadsheetExamples/SpreadsheetActions/FormattingActions.vb#L257

' Set the font name.
cellFont.Name = "Times New Roman"
' Set the font size.