.NET Framework 4.5.2+
.NET Framework 4.5.2+
.NET Standard 2.0+
A newer version of this page is available. Switch to the current version.

RangeDataSourceOptions.PreserveFormulas Property

Gets or sets whether to preserve formulas in the data source range.

Namespace: DevExpress.Spreadsheet

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


public bool PreserveFormulas { get; set; }

Property Value

Type Description

True, if the formulas cannot be modified; otherwise, false.


If the PreserveFormulas is set to true, an attempt to modify a cell value in a cell containing a formula results in an error. The WorksheetDataBindingCollection.Error event occurs. The error type is DataBindingErrorType.CannotModifyCellsWithFormulas.

See Also