Spread Windows Forms 7.0 Product Documentation
EditError Enumeration
Example  See Also  Support Options
FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace : EditError Enumeration

Glossary Item Box

Specifies the possible editor messages based on the user action.


Visual Basic (Declaration) 
Public Enum EditError 
   Inherits System.Enum
Visual Basic (Usage)Copy Code
Dim instance As EditError
public enum EditError : System.Enum 


CellIsLocked[1] Indicates the user attempted to interact with a locked cell.
ColumnAndRowRestrictedIndicates the user attempted to move the focus to a cell that is located in both a restricted row and column.
ColumnRestrictedIndicates the user attempted to move the focus to a restricted column.
InvalidCellDataIndicates the current input value in the editor is invalid
InvalidCellFormulaIndicates the user typed an invalid formula into a cell (sent when the user has left the cell).
InvalidCellValueIndicates the user typed invalid data into a cell (sent when the user has left the cell).
InvalidHyperlinkIndicates the user clicked a link that is invalid.
RowRestrictedIndicates the user attempted to move the focus to a restricted row.
TypedInCheckboxIndicates the user attempted to type in a check box cell.


This method provides possible error messages that can be displayed based on user action.


C#Copy Code
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;
Visual BasicCopy Code
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



Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8

See Also

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.