RangeDataSourceOptions.PreserveFormulas Property
Gets or sets whether to preserve formulas in the data source range.
Namespace: DevExpress.Spreadsheet
Assembly: DevExpress.Spreadsheet.v21.2.Core.dll
NuGet Package: DevExpress.Spreadsheet.Core
Declaration
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