Skip to main content

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

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

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.

See Also