Spread Silverlight Documentation
GrapeCity.Windows.SpreadSheet.UI Namespace / CellEventArgs Class / Row Property
Example


In This Topic
    Row Property (CellEventArgs)
    In This Topic
    Gets the row index of the cell.
    Syntax
    'Declaration
     
    Public ReadOnly Property Row As Integer
    'Usage
     
    Dim instance As CellEventArgs
    Dim value As Integer
     
    value = instance.Row
    public int Row {get;}

    Property Value

    The row index of the cell.
    Example
    This example uses the Row property.
    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