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

NuGet Package: DevExpress.Spreadsheet.Core

Declaration

C#

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

VB.NET

<DefaultValue(False)>
Public Property KeepCellAlignmentOnShowFormulas As Boolean

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.