Skip to main content

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

[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