CellEditorOpenedEventArgs.Editor Property

Returns the active cell editor.

Namespace: DevExpress.XtraSpreadsheet

Assembly: DevExpress.XtraSpreadsheet.v23.2.dll

NuGet Package: DevExpress.Win.Spreadsheet

Declaration

C#

public Control Editor { get; }

VB.NET

Public ReadOnly Property Editor As Control

Property Value

Type	Description
Control	An object that specifies the active editor.

Remarks

Use the CellEditorOpenedEventArgs.IsCustom and CellEditorOpenedEventArgs.CustomEditorType properties to determine the type of the active cell editor. Depending on these property values, you can cast the Editor value to the following controls:

Control	Description	IsCustom	CustomEditorType
System.Windows.Forms.TextBox	A Windows text box control (the default cell editor).	false
DevExpress.XtraEditors.ComboBoxEdit	A DevExpress combo box control.	true	ComboBox
DevExpress.XtraEditors.DateEdit	A DevExpress date picker control.	true	DateEdit
DevExpress.XtraEditors.CheckEdit	A DevExpress checkbox control.	true	CheckBox

The cast operation is not required if you handle the basic events (such as key and mouse events) for the cell editor.

Example. Use the CellEditorOpened Event to Validate User Input

The code sample below demonstrates how to use a regular expression to check that a user enters a US phone number in the correct format. If a user types an invalid number, the editor’s background color changes to Salmon. If a number in the correct format is entered, the editor’s background color resets to the original color and the phone number is converted to the following format: [phone].

C#

using System;
using System.Drawing;
using System.Text.RegularExpressions;

namespace SpreadsheetApp
{
    public partial class Form1 : DevExpress.XtraBars.Ribbon.RibbonForm
    {
        // Specify the regular expression to check a phone number.
        Regex phoneNumber = new Regex(@"^\(?([0-9]{3})\)?[-. ]?([0-9]{3})[-. ]?([0-9]{4})$");
        Color editorBackColor = Color.Transparent;

        public Form1()
        {
            InitializeComponent();
            spreadsheetControl1.CellEditorOpened += spreadsheetControl1_CellEditorOpened;
            spreadsheetControl1.LoadDocument(@"Documents\Employees.xlsx");
        }

        private void spreadsheetControl1_CellEditorOpened(object sender,
            DevExpress.XtraSpreadsheet.CellEditorOpenedEventArgs e)
        {
            // If a user activates an editor for a cell in the "Phone Number" column,
            // the editor's TextChanged event fires.
            if (spreadsheetControl1.ActiveCell.ColumnIndex == 5 &&
                spreadsheetControl1.ActiveCell.RowIndex > 3)
            {
                var editor = e.Editor;
                this.editorBackColor = editor.BackColor;
                editor.TextChanged += Editor_TextChanged;
            }
        }

        private void Editor_TextChanged(object sender, EventArgs e)
        {
            // Access the active cell editor. This example assumes
            // that the target cell contains the default editor
            // (a Windows text box control).
            var textEditor = sender as System.Windows.Forms.TextBox;
            if (textEditor == null)
                return;
            // If the entered number matches the specified regular expression,
            // convert this number to the standard phone number format.
            if (phoneNumber.IsMatch(textEditor.Text))
            {
                textEditor.Text = phoneNumber.Replace(textEditor.Text, "($1) $2-$3");
                textEditor.BackColor = editorBackColor;
            }
            else
                // Otherwise, change the editor's background to the Salmon color
                // to indicate that the user input is invalid.
                textEditor.BackColor = Color.Salmon;
        }
    }
}

VB.NET

Imports System
Imports System.Drawing
Imports System.Text.RegularExpressions
Imports System.Windows.Forms

Namespace SpreadsheetApp
    Public Class Form1
        Inherits DevExpress.XtraBars.Ribbon.RibbonForm

        ' Specify the regular expression to check a phone number.
        Private phoneNumber As New Regex("^\(?([0-9]{3})\)?[-. ]?([0-9]{3})[-. ]?([0-9]{4})$")
        Private editorBackColor As Color = Color.Transparent

        Public Sub New()
            InitializeComponent()
            AddHandler spreadsheetControl1.CellEditorOpened, AddressOf spreadsheetControl1_CellEditorOpened
            spreadsheetControl1.LoadDocument("Documents\Employees.xlsx")
        End Sub

        Private Sub spreadsheetControl1_CellEditorOpened(ByVal sender As Object,
            ByVal e As DevExpress.XtraSpreadsheet.CellEditorOpenedEventArgs)
            ' If a user activates an editor for a cell in the "Phone Number" column,
            ' the editor's TextChanged event fires.
            If spreadsheetControl1.ActiveCell.ColumnIndex = 5 AndAlso
                spreadsheetControl1.ActiveCell.RowIndex > 3 Then
                Dim editor As Control = e.Editor
                Me.editorBackColor = editor.BackColor
                AddHandler editor.TextChanged, AddressOf Editor_TextChanged
            End If
        End Sub

        Private Sub Editor_TextChanged(ByVal sender As Object, ByVal e As EventArgs)
            ' Access the active cell editor. This example assumes
            ' that the target cell contains the default editor
            ' (a Windows text box control).
            Dim textEditor As TextBox = TryCast(sender, TextBox)
            If textEditor Is Nothing Then
                Return
            End If
            ' If the entered number matches the specified regular expression,
            ' convert this number to the standard phone number format.
            If phoneNumber.IsMatch(textEditor.Text) Then
                textEditor.Text = phoneNumber.Replace(textEditor.Text, "($1) $2-$3")
                textEditor.BackColor = editorBackColor
            Else
                ' Otherwise, change the editor's background to the Salmon color
                ' to indicate that the user input is invalid.
                textEditor.BackColor = Color.Salmon
            End If
        End Sub
    End Class
End Namespace