SpreadsheetCellOptions.KeepCellAlignmentOnShowFormulas Property

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

Namespace: DevExpress.Xpf.Spreadsheet

Assembly: DevExpress.Xpf.Spreadsheet.v23.2.dll

NuGet Package: DevExpress.Wpf.Spreadsheet

Declaration

C#

public bool KeepCellAlignmentOnShowFormulas { get; set; }

VB.NET

Public Property KeepCellAlignmentOnShowFormulas As Boolean

Property Value

Type	Description
Boolean	true, to keep cell alignment when the Show Formulas option is activated; otherwise, false. The default is false.

Property Paths

You can access this nested property as listed below:

Object Type	Path to KeepCellAlignmentOnShowFormulas
SpreadsheetControlOptions	.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.