.NET Framework 4.5.2+
.NET Framework 4.5.2+
.NET Standard 2.0+

SpreadsheetCompatibilityOptions.EnableLegacyLayoutEngine Property

Enables the legacy layout calculation engine.

Namespace: DevExpress.XtraSpreadsheet

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


public bool EnableLegacyLayoutEngine { get; set; }

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 SpreadsheetControlOptions
Office File API DocumentOptions


In v19.1, the WinForms Spreadsheet control and Spreadsheet Document API introduced a new layout calculation engine with the following advantages:

  • We increased layout calculation speed and improved layout accuracy.

  • The Spreadsheet control’s render and scroll performance was optimized.

  • The Spreadsheet now exports documents to PDF faster and produces a more precise layout (see the SpreadsheetCompatibilityOptions.EnableLegacyPdfExport property for details).

  • A printed document’s layout is calculated more accurately (see the SpreadsheetCompatibilityOptions.EnableLegacyPrintLayout property for details).

  • We enhanced printing options: titles (rows and columns that repeat on every page) outside the print area can now be printed.

  • The Spreadsheet control can display cell text with the CenterContinuous alignment.

  • You can display, print, and export (to PDF) cells with rich text.

  • Headers and footers support rich text and inline images.

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

After the update, the way the Spreadsheet renders and prints certain documents can change. 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