officefileapi-devexpress-dot-xtraspreadsheet-dot-spreadsheetcolumnbehavioroptions-b35db2a2.md
Gets or sets the document’s capability to delete columns.
Namespace : DevExpress.XtraSpreadsheet
Assembly : DevExpress.Spreadsheet.v25.2.Core.dll
NuGet Package : DevExpress.Spreadsheet.Core
[DefaultValue(DocumentCapability.Default)]
public virtual DocumentCapability Delete { get; set; }
<DefaultValue(DocumentCapability.Default)>
Public Overridable Property Delete As DocumentCapability
| Type | Default | Description |
|---|---|---|
| DocumentCapability | Default |
A DocumentCapability enumeration value specifying the document’s capability to perform an operation.
|
Available values:
| Name | Description |
|---|---|
| Default |
The value is determined by the current setting. The default value is automatically set if it is not explicitly specified.
| | Disabled |
The feature is not allowed and the corresponding commands are shown disabled.
| | Enabled |
The feature is available and the corresponding commands are shown enabled.
| | Hidden |
The feature is not available and the corresponding commands are hidden.
|
You can access this nested property as listed below:
| Object Type | Path to Delete |
|---|---|
| SpreadsheetBehaviorOptions |
.Column .Delete
|
The DocumentCapability.Default value for the Delete property is equal to DocumentCapability.Enabled, so that deleting columns is available for a document currently loaded in the SpreadsheetControl.
The following code snippet (auto-collected from DevExpress Examples) contains a reference to the Delete property.
Note
The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.
winforms-spreadsheet-custom-draw-example/VB/CustomDrawExample/Form1.vb#L16
spreadsheetControl1.LoadDocument("Products.xlsx")
spreadsheetControl1.Options.Behavior.Column.Delete = DocumentCapability.Disabled
spreadsheetControl1.Options.Behavior.Column.Insert = DocumentCapability.Disabled
See Also
SpreadsheetColumnBehaviorOptions Class