Column Property (ValidationErrorEventArgs)

Visual Basic
C#

'Declaration
 
Public ReadOnly Property Column As System.Integer

'Usage
 
Dim instance As ValidationErrorEventArgs
Dim value As System.Integer
 
value = instance.Column

public System.int Column {get;}

Property Value

The column index.

This example uses the Column property. The event occurs if the typed data is less than three characters or greater than five.

C#

gcSpreadSheet1.ActiveSheet[1, 1, 3, 3].DataValidator = GrapeCity.Windows.SpreadSheet.Data.DataValidator.CreateTextLengthValidator(GrapeCity.Windows.SpreadSheet.Data.ComparisonOperator.Between, 3, 5);
private void gcSpreadSheet1_ValidationError(object sender, GrapeCity.Windows.SpreadSheet.UI.ValidationErrorEventArgs e)
        {
            listBox1.Items.Add(e.Column.ToString());
            listBox1.Items.Add(e.Row.ToString());
            listBox1.Items.Add(e.ValidationResult.ToString());
            listBox1.Items.Add(e.Validator.ToString());
            e.ValidationResult = GrapeCity.Windows.SpreadSheet.UI.UndoRedo.DataValidationResult.Discard;
        }

        private void gcSpreadSheet1_ValueChanged(object sender, GrapeCity.Windows.SpreadSheet.UI.CellEventArgs e)
        {
            listBox1.Items.Add(e.Column.ToString());
            listBox1.Items.Add(e.Row.ToString());
        }

VB.NET

GcSpreadSheet1.ActiveSheet(1, 1, 3, 3).DataValidator = GrapeCity.Windows.SpreadSheet.Data.DataValidator.CreateTextLengthValidator(GrapeCity.Windows.SpreadSheet.Data.ComparisonOperator.Between, 3, 5)

Private Sub GcSpreadSheet1_ValidationError(sender As System.Object, e As GrapeCity.Windows.SpreadSheet.UI.ValidationErrorEventArgs) Handles GcSpreadSheet1.ValidationError
        ListBox1.Items.Add(e.Column.ToString())
        ListBox1.Items.Add(e.Row.ToString())
        ListBox1.Items.Add(e.ValidationResult.ToString())
        ListBox1.Items.Add(e.Validator.ToString())
        e.ValidationResult = GrapeCity.Windows.SpreadSheet.UI.UndoRedo.DataValidationResult.Discard
    End Sub

Private Sub GcSpreadSheet1_ValueChanged(sender As System.Object, e As GrapeCity.Windows.SpreadSheet.UI.CellEventArgs) Handles GcSpreadSheet1.ValueChanged
        ListBox1.Items.Add(e.Column.ToString())
        ListBox1.Items.Add(e.Row.ToString())
    End Sub

Reference

ValidationErrorEventArgs Class
ValidationErrorEventArgs Members