Visual Basic (Declaration) | |
---|---|
Public Enum EditError Inherits System.Enum |
Visual Basic (Usage) | Copy Code |
---|---|
Dim instance As EditError |
C# | |
---|---|
public enum EditError : System.Enum |
Member | Description |
---|---|
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. |
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 Basic | Copy 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 |
System.Object
System.ValueType
System.Enum
FarPoint.Win.Spread.EditError
Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8
Reference
FarPoint.Win.Spread NamespaceEditError Event (FpSpread Class)
EditError Property (EditErrorEventArgs Class)