DataValidationListPopupOpening Event (GcSpreadSheet)

Visual Basic
C#

'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

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.

Property	Description
Cancel	(Inherited from System.ComponentModel.CancelEventArgs)
Column	Gets the column index of the cell.
Row	Gets the row index of the cell.

This example uses the DataValidationListPopupOpening event.

C#
VB.NET

private void Grid_Loaded_1(object sender, RoutedEventArgs e)
        {
            GcSpreadSheet1.HighlightInvalidData = true;
            var valid = GrapeCity.Xaml.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.Xaml.SpreadSheet.UI.CellCancelEventArgs e)
        {
            TextBox1.Text = e.Column.ToString();
        }

GcSpreadSheet1.HighlightInvalidData = True
Dim valid = GrapeCity.Xaml.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.Xaml.SpreadSheet.UI.CellCancelEventArgs) Handles GcSpreadSheet1.DataValidationListPopupOpening
TextBox1.Text = e.Column.ToString()
End Sub

Target Platforms: Windows Server 2012, Windows RT

Reference

GcSpreadSheet Class
GcSpreadSheet Members