Skip to main content

DevExpress v24.2 Update — Your Feedback Matters

Our What's New in v24.2 webpage includes product-specific surveys. Your response to our survey questions will help us measure product satisfaction for features released in this major update and help us refine our plans for our next major release.

Take the survey Not interested

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.2.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