RichTextRange.SetFont(SpreadsheetFont) Method

Applies the specified font settings to the current region of the cell text.

Namespace: DevExpress.Spreadsheet

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

NuGet Package: DevExpress.Spreadsheet.Core

Declaration

C#

void SetFont(
    SpreadsheetFont font
)

VB.NET

Sub SetFont(
    font As SpreadsheetFont
)

Parameters

Name	Type	Description
font	SpreadsheetFont	A SpreadsheetFont object or its descendant, a RichTextRunFont object, containing the necessary font settings.

Remarks

Use the SetFont method to apply a custom font to a portion of the cell text specified by the RichTextString.Characters method. To assign the rich formatted text to a cell, call the CellRange.SetRichText method.

C#

// Create a RichTextString instance.
RichTextString richText = new RichTextString();

// Specify the cell text.
richText.Text = "Rich text formatting";
// Change font characteristics of the first word.
richText.Characters(0, 4).SetFont(new RichTextRunFont("Calibri", 12, System.Drawing.Color.Red));

// Assign the rich formatted text to the cell B2.
worksheet["B2"].SetRichText(richText);

VB.NET

' Create a RichTextString instance.
Dim richText As New RichTextString()

' Specify the cell text.
richText.Text = "Rich text formatting"
' Change font characteristics of the first word.
richText.Characters(0, 4).SetFont(New RichTextRunFont("Calibri", 12, System.Drawing.Color.Red))

' Assign the rich formatted text to the cell B2.
worksheet("B2").SetRichText(richText)

Refer to the How to: Apply Rich Formatting to Cell Text document for more examples on how to apply rich formatting to the cell content.