SpreadsheetColumnBehaviorOptions.Delete Property

Gets or sets the document’s capability to delete columns.

Namespace: DevExpress.XtraSpreadsheet

Assembly: DevExpress.Spreadsheet.v19.1.Core.dll

Declaration

C#

[DefaultValue(DocumentCapability.Default)]
public virtual DocumentCapability Delete { get; set; }

VB.NET

<DefaultValue(DocumentCapability.Default)>
Public Overridable Property Delete As DocumentCapability

Property Value

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.

Property Paths

You can access this nested property as listed below:

Object Type	Path to Delete
SpreadsheetBehaviorOptions	.Column.Delete

Remarks

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.

Related GitHub Examples

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.

C#

xtraspreadsheet-custom-draw-examples-e5044/CS/CustomDrawExample/Form1.cs#L19

spreadsheetControl1.Document.DocumentSettings.R1C1ReferenceStyle = true;
spreadsheetControl1.Options.Behavior.Column.Delete = DocumentCapability.Disabled;
spreadsheetControl1.Options.Behavior.Column.Insert = DocumentCapability.Disabled;

VB.NET

xtraspreadsheet-custom-draw-examples-e5044/VB/CustomDrawExample/Form1.vb#L18

spreadsheetControl1.Document.DocumentSettings.R1C1ReferenceStyle = True
spreadsheetControl1.Options.Behavior.Column.Delete = DocumentCapability.Disabled
spreadsheetControl1.Options.Behavior.Column.Insert = DocumentCapability.Disabled