The requested page is not available for the requested platform. You are viewing the content for .NET Framework 4.5.2+ platform.
.NET Framework 4.5.2+
.NET Framework 4.5.2+
.NET Standard 2.0+
.NET Core 3.0+
Row

RangeDataSourceOptions.PreserveFormulas Property

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

Namespace: DevExpress.Spreadsheet

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

Declaration

public bool PreserveFormulas { get; set; }
Public Property PreserveFormulas As Boolean
public bool PreserveFormulas { get; set; }
Public Property PreserveFormulas As Boolean
public bool PreserveFormulas { get; set; }
Public Property PreserveFormulas As Boolean

Property Value

Type Description
Boolean

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

Property Value

Type Description
Boolean

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

Property Value

Type Description
Boolean

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

Remarks

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