ClipboardOptions.AllowExcelFormat Property
Gets or sets whether copying data in XLS (Biff8) format is enabled.
Namespace: DevExpress.Export
Assembly: DevExpress.Data.v20.2.dll
NuGet Packages: DevExpress.Data, DevExpress.WindowsDesktop.Data
Declaration
[DefaultValue(DefaultBoolean.Default)]
public DefaultBoolean AllowExcelFormat { get; set; }
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 | Corresponds to a Boolean value of true. |
False | Corresponds to a Boolean value of false. |
Default | The value is determined by the current object’s parent object setting (e.g., a control setting). |
Property Paths
You can access this nested property as listed below:
Library | Object Type | Path to AllowExcelFormat |
---|---|---|
WinForms Controls | GanttControl |
|
AdvBandedGridView |
|
|
BandedGridView |
|
|
GridView |
|
|
ResourcesTree |
|
|
TreeList |
|
|
Reporting | XRDesignFieldList |
|
XRDesignReportExplorer |
|
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.