officefileapi-devexpress-dot-spreadsheet-dot-rangedatasourceoptions-aeecfc1f.md
Gets or sets whether to preserve formulas in the data source range.
Namespace : DevExpress.Spreadsheet
Assembly : DevExpress.Spreadsheet.v25.2.Core.dll
NuGet Package : DevExpress.Spreadsheet.Core
public bool PreserveFormulas { get; set; }
Public Property PreserveFormulas As Boolean
| Type | Description |
|---|---|
| Boolean |
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.
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.
RangeDataSourceOptions options = new RangeDataSourceOptions();
options.PreserveFormulas = true;
options.SkipHiddenRows = true;
Dim options As New RangeDataSourceOptions()
options.PreserveFormulas = True
options.SkipHiddenRows = True
See Also