EditError Enumeration

Specifies the possible editor messages based on the user action.

Syntax

Visual Basic
C#

'Declaration
 
Public Enum EditError 
   Inherits System.Enum

'Usage
 
Dim instance As EditError

public enum EditError : System.Enum

Members

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.

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;
    }
}

Visual Basic

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

Requirements

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

Reference

FarPoint.Win.Spread Namespace
EditError Event (FpSpread Class)
EditError Property (EditErrorEventArgs Class)

User-Task Documentation

Customizing User Error Messages