officefileapi-devexpress-dot-spreadsheet-dot-rangedatasourceoptions-48524954.md
Gets or sets the editing options for the data source range.
Namespace : DevExpress.Spreadsheet
Assembly : DevExpress.Spreadsheet.v25.2.Core.dll
NuGet Package : DevExpress.Spreadsheet.Core
public DataSourceEditingOptions EditingOptions { get; set; }
Public Property EditingOptions As DataSourceEditingOptions
| Type | Description |
|---|---|
| DataSourceEditingOptions |
One of the DataSourceEditingOptions enumeration values indicating the available editing options.
|
Available values:
| Name | Description |
|---|---|
| AllowEdit |
Editing is allowed.
| | AllowNew |
Adding new rows is allowed.
| | AllowRemove |
Removing rows is allowed.
| | AllowSort |
Sorting is allowed.
| | Default |
Every editing operation is allowed.
| | ReadOnly |
Every editing operation is forbidden.
|
The following code snippet (auto-collected from DevExpress Examples) contains a reference to the EditingOptions 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-use-cell-range-as-data-source/CS/RangeDataSource/Form1.cs#L54
}
options.EditingOptions = DataSourceEditingOptions.ReadOnly;
options.SkipHiddenColumns = false;
winforms-spreadsheet-use-cell-range-as-data-source/VB/RangeDataSource/Form1.vb#L60
options.EditingOptions = DataSourceEditingOptions.ReadOnly
options.SkipHiddenColumns = False
See Also