Spread Windows Forms 10.0 Product Documentation
EditError Enumeration
Example Example 


Specifies the possible editor messages based on the user action.
Syntax
'Declaration
 
Public Enum EditError 
   Inherits System.Enum
'Usage
 
Dim instance As EditError
public enum EditError : System.Enum 
Members
MemberDescription
CellIsLocked[1] Indicates the user attempted to interact with a locked cell.
ColumnAndRowRestrictedIndicates the user attempted to move the focus to a cell that is located in both a restricted row and column.
ColumnRestrictedIndicates the user attempted to move the focus to a restricted column.
InvalidCellDataIndicates the current input value in the editor is invalid
InvalidCellFormulaIndicates the user typed an invalid formula into a cell (sent when the user has left the cell).
InvalidCellValueIndicates the user typed invalid data into a cell (sent when the user has left the cell).
InvalidHyperlinkIndicates the user clicked a link that is invalid.
RowRestrictedIndicates the user attempted to move the focus to a restricted row.
TypedInCheckboxIndicates 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;
    }
}
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

See Also

Reference

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

User-Task Documentation

Customizing User Error Messages

 

 


Copyright © GrapeCity, inc. All rights reserved.