ClipboardOptions.AllowExcelFormat Property

Gets or sets whether copying data in XLS (Biff8) format is enabled.

Namespace: DevExpress.Export

Assembly: DevExpress.Data.v21.2.dll

NuGet Packages: DevExpress.Data, DevExpress.Win.Design

Declaration

C#

[DefaultValue(DefaultBoolean.Default)]
public DefaultBoolean AllowExcelFormat { get; set; }

VB.NET

<DefaultValue(DefaultBoolean.Default)>
Public Property AllowExcelFormat As DefaultBoolean

Property Value

Type	Default	Description
DefaultBoolean	Default	A value that specifies whether copying data in XLS (Biff8) format is enabled. The Default value is equivalent to DefaultBoolean.True.

Available values:

Name	Description
True	true. DefaultBoolean.True has a constant value of 0, while the standard true value corresponds to a value of 1. In Visual Basic, do not use implicit conversion of Boolean values to DefaultBoolean, and vice versa, as the conversion may produce incorrect results.
False	false. DefaultBoolean.False has a constant value of 1, while the standard false value corresponds to a value of 0. In Visual Basic, do not use implicit conversion of Boolean values to DefaultBoolean, and vice versa, as the conversion may produce incorrect results.
Default	The default behavior determined by the control’s logic.

Remarks

The AllowExcelFormat option is in effect if the ClipboardOptions.ClipboardMode property is set to Formatted. See Clipboard - Copy and Paste Operations. Data Formatting to learn more.

Note

Due to Excel limitations, it is impossible to paste formatted data when copying from more than 65,653 cells. Instead, copied data will be pasted as an RTF or, if this option is disabled, as simple plain text.