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 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8

Reference

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

User-Task Documentation

Customizing User Error Messages