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

C#

public bool PreserveFormulas { get; set; }

VB.NET

Public Property PreserveFormulas As Boolean

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.

Related GitHub Examples

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.

C#

wpf-spreadsheet-bind-grid-control-to-worksheet-data/CS/WpfSpreadsheet_DataBinding/MainWindow.xaml.cs#L29

RangeDataSourceOptions options = new RangeDataSourceOptions();
options.PreserveFormulas = true;
options.SkipHiddenRows = true;

VB.NET

wpf-spreadsheet-bind-grid-control-to-worksheet-data/VB/WpfSpreadsheet_DataBinding/MainWindow.xaml.vb#L27

Dim options As New RangeDataSourceOptions()
options.PreserveFormulas = True
options.SkipHiddenRows = True