DataBindingErrorType Enum | Office File API | DevExpress Documentation Skip to main content

Chat Now

Buy Support Center Documentation Training Free Trial

Download CHM

DataBindingErrorType Enum

Lists possible error causes relevant to cell range data binding.

Namespace: DevExpress.Spreadsheet

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

Declaration

C#
VB.NET

public enum DataBindingErrorType

Public Enum DataBindingErrorType

Members

Name	Description
`CannotDeleteLastRow`	When a cell range serves as a data source, an attempt to remove a row fails if it is the only row in the data source, because the data source must contain at least one row.
`BindingRangeHasMergedCells`	When binding a cell range to the data source, the range has merged cells, which is not allowed.
`MaximumNumberOfRowsExceeded`	When binding a cell range to the data source, the error occurs when the index of a row required to bind to the data source record exceeds the maximum number of rows allowed in the worksheet.
`MaximumNumberOfColumnsExceeded`	When binding a cell range to the data source, the error occurs when the index of a column required to bind to the data source field exceeds the maximum number of columns allowed in the worksheet.
`CannotInsertRows`	When binding a cell range to the data source, the range cannot insert rows to accommodate new data rows in the data source. This may happen in a situation when there are two binding ranges on the same worksheet placed horizontally one after another, and one range is bound to a read-only data source. When a record is added to the editable data source, the corresponding range cannot insert a row to display the record because such insertion is prohibited by the read-only status of another binding range.
`CannotRemoveRows`	When binding a cell range to the data source, the range cannot remove rows to reflect row removal in the data source. This may happen in a situation when there are two binding ranges on the same worksheet placed horizontally one after another, and one range is bound to a read-only data source. When a record is removed from the editable data source, the corresponding range cannot remove a row to display the record because such removal is prohibited by the read-only status of another binding range.
`DataOutOfSync`	When binding a cell range to the data source, indicates that the number of data rows in the binding range and in the data source differ. This error may occur after row insertion or deletion from a data source bound to the range which cannot insert or delete rows.
`CannotModifyCellsWithFormulas`	When a cell range serves as a data source and the RangeDataSourceOptions.PreserveFormulas option has been set to true, an attempt to modify a cell value fails if a cell contains a formula.
`ColumnCountMismatch`	Indicates that the number of data fields in the bound data source exceeds the number of rows in the target worksheet range.

Related API Members

The following properties accept/return DataBindingErrorType values:

Example

View Example

    spreadsheetControl1.Document.Worksheets[0].DataBindings.Error += DataBindings_Error;
private void DataBindings_Error(object sender, DataBindingErrorEventArgs e) {
    MessageBox.Show(String.Format("Error at worksheet.Rows[{0}].\n The error is : {1}", e.RowIndex, e.ErrorType.ToString()), "Binding Error");
}

    AddHandler spreadsheetControl1.Document.Worksheets(0).DataBindings.Error, AddressOf DataBindings_Error
Private Sub DataBindings_Error(ByVal sender As Object, ByVal e As DataBindingErrorEventArgs)
    MessageBox.Show(String.Format("Error at worksheet.Rows[{0}]." & ControlChars.Lf & " The error is : {1}", e.RowIndex, e.ErrorType.ToString()), "Binding Error")
End Sub

Sunbelt Computer Software

PL/B Language Development and Support

Controls

FREE UTILITIES

Controls and Extensions

FREE UTILITIES

Controls

FREE UTILITIES

Controls and Extensions

FREE UTILITIES

DataBindingErrorType Enum

Declaration

Members

Related API Members

Example