Spread WPF Documentation
Validator Property
Example 


GrapeCity.Windows.SpreadSheet.UI Namespace > ValidationErrorEventArgs Class : Validator Property
Gets the validator which caused this error. This validator is a copy of the real validator, so any modifications to this validator do not take effect.
Syntax
'Declaration
 
Public ReadOnly Property Validator As DataValidator
'Usage
 
Dim instance As ValidationErrorEventArgs
Dim value As DataValidator
 
value = instance.Validator
public DataValidator Validator {get;}
Example
This example uses the Validator property. The event occurs if the typed data is less than three characters or greater than five.
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());
        }
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
See Also

Reference

ValidationErrorEventArgs Class
ValidationErrorEventArgs Members