ValueChanged Event (GcSpreadSheet)

Occurs when the value in the subeditor changes.

Syntax

Visual Basic
C#

'Declaration
 
Public Event ValueChanged As EventHandler(Of CellEventArgs)

'Usage
 
Dim instance As GcSpreadSheet
Dim handler As EventHandler(Of CellEventArgs)
 
AddHandler instance.ValueChanged, handler

public event EventHandler<CellEventArgs> ValueChanged

Event Data

The event handler receives an argument of type CellEventArgs containing data related to this event. The following CellEventArgs properties provide information specific to this event.

Property	Description
Column	Gets the column index of the cell.
Row	Gets the row index of the cell.

Example

This example uses the ValueChanged event.

C#
VB.NET

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

Reference

GcSpreadSheet Class
GcSpreadSheet Members

Product Support Forum | Print this page