.NET Framework 4.5.2+
.NET Framework 4.5.2+
.NET Standard 2.0+
A newer version of this page is available. Switch to the current version.

SpreadsheetCompatibilityOptions.EnableLegacyLayoutEngine Property

Gets or sets whether to use the legacy layout calculation engine.

Namespace: DevExpress.XtraSpreadsheet

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


public bool EnableLegacyLayoutEngine { get; set; }
Public Property EnableLegacyLayoutEngine As Boolean

Property Value

Type Description

true, to enable the legacy layout engine; otherwise, false. The default value is false.

Property Paths

You can access this nested property as listed below:

Library Object Type Path to EnableLegacyLayoutEngine
WinForms Controls SpreadsheetControl
Office File API DocumentOptions


The WinForms Spreadsheet control and Spreadsheet Document API introduced a new layout calculation engine in v19.1. Its advantages are as follows:

  • Increased layout calculation performance and improved layout accuracy.

  • Optimized render and scroll performance for the Spreadsheet control.

  • The ability to display, print and export (to PDF) rich formatted cell text.

  • Support for rich text and inline images in headers and footers.

  • Enhanced printing capabilities: you can specify print titles outside the print area.

  • Support for the SpreadsheetHorizontalAlignment.CenterContinuous alignment option.

  • The CustomDrawCell and CustomDrawCellBackground events fire for all cells in the visible worksheet area.

After the update, the Spreadsheet may slightly change how it renders and prints certain documents. Activate the EnableLegacyLayoutEngine property to disable the new layout engine and its features.

Disable the new layout engine for a Workbook instance.

workbook.Options.Compatibility.EnableLegacyLayoutEngine = true;

Disable the new layout engine for the Spreadsheet control.

spreadsheetControl.Options.Compatibility.EnableLegacyLayoutEngine = true;
See Also