SpreadsheetClipboardOptions.AllowFormulasInBiff8 Property
Returns or specifies whether to copy cell formulas when you copy and paste data from the current Spreadsheet control to another SpreadsheetControl instance.
Namespace: DevExpress.XtraSpreadsheet
Assembly: DevExpress.Spreadsheet.v24.1.Core.dll
NuGet Package: DevExpress.Spreadsheet.Core
Declaration
Property Value
Type | Default | Description |
---|---|---|
Boolean | false | true to copy formulas; otherwise, false. |
Property Paths
You can access this nested property as listed below:
Object Type | Path to AllowFormulasInBiff8 |
---|---|
DocumentOptions |
|
Remarks
When a cell range is copied from one SpreadsheetControl instance to another Spreadsheet control, formulas are calculated and their values are pasted into destination cells.
To change this behavior and copy formulas, set the AllowFormulasInBiff8 property of the source Spreadsheet control to true. When you paste cell values into Microsoft® Excel®, the AllowFormulasInBiff8 property value is ignored and only formula values are inserted.