Skip to main content

DevExpress v24.2 Update — Your Feedback Matters

Our What's New in v24.2 webpage includes product-specific surveys. Your response to our survey questions will help us measure product satisfaction for features released in this major update and help us refine our plans for our next major release.

Take the survey Not interested

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.2.Core.dll

NuGet Package: DevExpress.Spreadsheet.Core

#Declaration

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

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

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

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

See Also