gcSpreadSheet1.ActiveSheet[1, 1, 3, 3].DataValidator = GrapeCity.Xaml.SpreadSheet.Data.DataValidator.CreateTextLengthValidator(GrapeCity.Xaml.SpreadSheet.Data.ComparisonOperator.Between, 3, 5);
private void gcSpreadSheet1_ValidationError(object sender, GrapeCity.Xaml.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.Xaml.SpreadSheet.UI.UndoRedo.DataValidationResult.Discard;
}
private void gcSpreadSheet1_ValueChanged(object sender, GrapeCity.Xaml.SpreadSheet.UI.CellEventArgs e)
{
listBox1.Items.Add(e.Column.ToString());
listBox1.Items.Add(e.Row.ToString());
}
GcSpreadSheet1.ActiveSheet(1, 1, 3, 3).DataValidator = GrapeCity.Xaml.SpreadSheet.Data.DataValidator.CreateTextLengthValidator(GrapeCity.Xaml.SpreadSheet.Data.ComparisonOperator.Between, 3, 5)
Private Sub GcSpreadSheet1_ValidationError(sender As Object, e As GrapeCity.Xaml.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.Xaml.SpreadSheet.UI.UndoRedo.DataValidationResult.Discard
End Sub
Private Sub GcSpreadSheet1_ValueChanged(sender As Object, e As GrapeCity.Xaml.SpreadSheet.UI.CellEventArgs) Handles GcSpreadSheet1.ValueChanged
ListBox1.Items.Add(e.Column.ToString())
ListBox1.Items.Add(e.Row.ToString())
End Sub