| 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)