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.v24.1.Core.dll

NuGet Package: DevExpress.Spreadsheet.Core

Declaration

C#

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

VB.NET

<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#

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

VB.NET

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

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