Skip to main content
Row

RangeDataSourceOptions.PreserveFormulas Property

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

Namespace: DevExpress.Spreadsheet

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

NuGet Package: DevExpress.Spreadsheet.Core

Declaration

public bool PreserveFormulas { get; set; }

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.

The following code snippet (auto-collected from DevExpress Examples) contains a reference to the PreserveFormulas property.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

See Also