Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread Namespace / EditError Enumeration
Example Example


In This Topic
    EditError Enumeration
    In This Topic
    Specifies the possible editor messages based on the user action.
    Syntax
    'Declaration
     
    Public Enum EditError 
       Inherits System.Enum
    'Usage
     
    Dim instance As EditError
    public enum EditError : System.Enum 
    Members
    MemberDescription
    CellIsLocked [1] Indicates the user attempted to interact with a locked cell.
    ColumnAndRowRestricted Indicates the user attempted to move the focus to a cell that is located in both a restricted row and column.
    ColumnRestricted Indicates the user attempted to move the focus to a restricted column.
    InvalidCellData Indicates the current input value in the editor is invalid
    InvalidCellFormula Indicates the user typed an invalid formula into a cell (sent when the user has left the cell).
    InvalidCellValue Indicates the user typed invalid data into a cell (sent when the user has left the cell).
    InvalidHyperlink Indicates the user clicked a link that is invalid.
    RowRestricted Indicates the user attempted to move the focus to a restricted row.
    TypedInCheckbox Indicates the user attempted to type in a check box cell.
    Remarks
    This method provides possible error messages that can be displayed based on user action.
    Example
    private void fpSpread1EditError(object sender, FarPoint.Win.Spread.EditErrorEventArgs e)
    {
        if(e.EditError == FarPoint.Win.Spread.EditError.CellIsLocked)
        {
            e.View.Sheets[0].Cells[e.Row, e.Column].BackColor = Color.Red;
        }
    }
    
    Private Sub FpSpread1EditError(ByVal sender As Object, ByVal e As FarPoint.Win.Spread.EditErrorEventArgs) Handles FpSpread1.EditError
        If e.EditError = FarPoint.Win.Spread.EditError.CellIsLocked Then
            e.View.Sheets(0).Cells(e.Row, e.Column).BackColor = Color.Red
        End If
    End Sub
    
    Inheritance Hierarchy

    System.Object
       System.ValueType
          System.Enum
             FarPoint.Win.Spread.EditError

    See Also