Skip to main content

ClipboardOptions.AllowExcelFormat Property

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

Namespace: DevExpress.Export

Assembly: DevExpress.Data.v24.1.dll

NuGet Package: DevExpress.Data

Declaration

[XtraSerializableProperty]
public DefaultBoolean AllowExcelFormat { get; set; }

Property Value

Type Description
DefaultBoolean

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 Return Value
True

The value is true.

0

False

The value is false.

1

Default

The value is specified by a global option or a higher-level object.

2

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.

See Also