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


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

    Property Value

    The column index of the cell.
    Example
    This example uses the Column 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