Skip to main content

SpreadsheetCellOptions.KeepCellAlignmentOnShowFormulas Property

Gets or sets a value indicating whether cell alignment should be preserved when the Show Formulas mode is enabled.

Namespace: DevExpress.XtraSpreadsheet

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

NuGet Package: DevExpress.Spreadsheet.Core

Declaration

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

Property Value

Type Default Description
Boolean false

true, to keep cell alignment when the Show Formulas option is activated; otherwise, false.

Property Paths

You can access this nested property as listed below:

Object Type Path to KeepCellAlignmentOnShowFormulas
DocumentOptions
.Cells .KeepCellAlignmentOnShowFormulas

Remarks

By default, when you activate the Show Formulas mode in the SpreadsheetControl to display formulas instead of formula results, all cells containing numbers will be left-aligned. To keep cell alignment as is when the ShowFormulas mode is enabled, set the KeepCellAlignmentOnShowFormulas property to true.

See Also