Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread Namespace / ErrorEventArgs Class / Column Property
Example


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

    Property Value

    Integer index of the column of the cell with the editor that raised the event
    Example
    This example displays an error message.
    void fpSpread1Error(object sender, ErrorEventArgs e)
    {
          if ((e.EditError == FarPoint.Win.Spread.EditError.InvalidCellData))
          {
                if ((e.IsEditError == true))
                {
                      e.Cancel = true;
                      MessageBox.Show(e.ErrorMessage);
                      e.View.Sheets[0].Cells[e.Row, e.Column].BackColor = Color.Red;
                }
          }
    }
    
    Private Sub FpSpread1Error(ByVal sender As Object, ByVal e As FarPoint.Win.Spread.ErrorEventArgs) Handles FpSpread1.Error
          If e.EditError = Win.Spread.EditError.InvalidCellData Then
                If e.IsEditError = True Then
                      e.Cancel = True
                      MessageBox.Show(e.ErrorMessage)
                      e.View.Sheets(0).Cells(e.Row, e.Column).BackColor = Color.Red
                End If
          End If
    End Sub
    See Also