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 inputing value in editor is invalid |
InvalidCellFormula | Indicates the user typed an invalid formula into a cell (sent when the user left the cell). |
InvalidCellValue | Indicates the user typed invalid data into a cell (sent when the user 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 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2
Reference
FarPoint.Win.Spread NamespaceEditError Event (FpSpread Class)
EditError Property (EditErrorEventArgs Class)