Skip to main content

DevExpress v24.2 Update — Your Feedback Matters

Our What's New in v24.2 webpage includes product-specific surveys. Your response to our survey questions will help us measure product satisfaction for features released in this major update and help us refine our plans for our next major release.

Take the survey Not interested

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.2.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