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.v19.1.Core.dll

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:

Library	Object Type	Path to KeepCellAlignmentOnShowFormulas
WinForms Controls	SpreadsheetControlOptions	.Cells.KeepCellAlignmentOnShowFormulas
Office File API	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.