Spread WPF 14
GrapeCity.Windows.SpreadSheet.UI Namespace / GcSpreadSheet Class / DataValidationListPopupOpening Event
Example


In This Topic
    DataValidationListPopupOpening Event (GcSpreadSheet)
    In This Topic
    Occurs when a data validation list popup is opening.
    Syntax
    'Declaration
     
    Public Event DataValidationListPopupOpening As EventHandler(Of CellCancelEventArgs)
    'Usage
     
    Dim instance As GcSpreadSheet
    Dim handler As EventHandler(Of CellCancelEventArgs)
     
    AddHandler instance.DataValidationListPopupOpening, handler
    public event EventHandler<CellCancelEventArgs> DataValidationListPopupOpening
    Event Data

    The event handler receives an argument of type CellCancelEventArgs containing data related to this event. The following CellCancelEventArgs properties provide information specific to this event.

    PropertyDescription
    (Inherited from System.ComponentModel.CancelEventArgs)
    Gets the column index of the cell.  
    Gets the row index of the cell.  
    Example
    This example uses the DataValidationListPopupOpening event.
    GcSpreadSheet1.HighlightInvalidData = true;
    var valid = GrapeCity.Windows.SpreadSheet.Data.DataValidator.CreateListValidator("5,10,15,20");
    GcSpreadSheet1.Sheets[0].Cells[0, 1].DataValidator = valid;
    GcSpreadSheet1.Sheets[0].Cells[0, 0].Text = "5, 10, 15, and 20 are valid numbers.";
    
    private void GcSpreadSheet1_DataValidationListPopupOpening(object sender, GrapeCity.Windows.SpreadSheet.UI.CellCancelEventArgs e)
            {
                TextBox1.Text = e.Column.ToString();
            }
    GcSpreadSheet1.HighlightInvalidData = True
    Dim valid = GrapeCity.Windows.SpreadSheet.Data.DataValidator.CreateListValidator("5,10,15,20")
    GcSpreadSheet1.Sheets(0).Cells(0, 1).DataValidator = valid
    GcSpreadSheet1.Sheets(0).Cells(0, 0).Text = "5, 10, 15, and 20 are valid numbers."
    
    Private Sub GcSpreadSheet1_DataValidationListPopupOpening(sender As Object, e As GrapeCity.Windows.SpreadSheet.UI.CellCancelEventArgs) Handles GcSpreadSheet1.DataValidationListPopupOpening
    TextBox1.Text = e.Column.ToString()
        End Sub
    See Also