SpreadsheetViewOptions.UseFontSubstitution Property

Gets or sets whether to use font substitution to display characters that are missing in the current font.

Namespace : DevExpress.XtraSpreadsheet

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

NuGet Package : DevExpress.Spreadsheet.Core

Declaration

C#
VB.NET

csharp

[DefaultValue(false)]
public bool UseFontSubstitution { get; set; }

<DefaultValue(False)>
Public Property UseFontSubstitution As Boolean

Property Value

Type	Default	Description
Boolean	false

true to enable font substitution; otherwise, false.

Property Paths

You can access this nested property as listed below:

Object Type	Path to UseFontSubstitution
SpreadsheetControlOptions

.View .UseFontSubstitution

Remarks

When the UseFontSubstitution property is true , the Spreadsheet control substitutes fonts for characters that are missing in the current font. If a suitable font is found in a font cache, the Spreadsheet applies it to the entire cell text. This option specifies only how a document is displayed on screen and doesn’t affect printing or export to PDF (they use their own mechanism of font substitution).

C#
VB.NET

csharp

// Enable font substitution.
spreadsheetControl1.Options.View.UseFontSubstitution = true;

' Enable font substitution.
spreadsheetControl1.Options.View.UseFontSubstitution = True

The UseFontSubstitution property is in effect only if the new Spreadsheet layout engine is used.