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.v23.2.Core.dll

NuGet Package: DevExpress.Spreadsheet.Core

Declaration

C#

[Browsable(false)]
[DefaultValue(false)]
public bool AllowFormulasInBiff8 { get; set; }

VB.NET

<DefaultValue(False)>
<Browsable(False)>
Public Property AllowFormulasInBiff8 As Boolean

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	.Clipboard .AllowFormulasInBiff8

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.