Spread WPF Documentation
ValidationResult Property
Example 


GrapeCity.Windows.SpreadSheet.UI Namespace > ValidationErrorEventArgs Class : ValidationResult Property
Gets or sets the policy that the user can set to determine how to process the error.
Syntax
'Declaration
 
Public Property ValidationResult As DataValidationResult
'Usage
 
Dim instance As ValidationErrorEventArgs
Dim value As DataValidationResult
 
instance.ValidationResult = value
 
value = instance.ValidationResult
public DataValidationResult ValidationResult {get; set;}
Example
This example uses the ValidationResult 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