NonEditModeValidation Property

Gets or sets whether to perform validation when Spread in non-editing state.

Syntax

Visual Basic
C#

'Declaration
 
Public Property NonEditModeValidation As Boolean

'Usage
 
Dim instance As FpSpread
Dim value As Boolean
 
instance.NonEditModeValidation = value
 
value = instance.NonEditModeValidation

public bool NonEditModeValidation {get; set;}

Example

This example sets the NonEditModeValidation property.

<asp:RegularExpressionValidator ID="RegularExpressionValidator1" runat="server" ControlToValidate="TextBox1" ErrorMessage="RegularExpressionValidator" ValidationExpression="\d{5}">Enter 5 digits</asp:RegularExpressionValidator>

 protected void Page_Load(object sender, EventArgs e)
        {
            FpSpread1.NonEditModeValidation = true;
            FarPoint.Web.Spread.TextCellType tcell1 = new FarPoint.Web.Spread.TextCellType();
            tcell1.Validators.Add(RegularExpressionValidator1);
            FpSpread1.ActiveSheetView.Columns[1].CellType = tcell1;
            FpSpread1.ActiveSheetView.Columns[1].BackColor = System.Drawing.Color.AliceBlue;
            FpSpread1.ValidationErrorMessage = "test";
        }

Visual Basic

<asp:RegularExpressionValidator ID="RegularExpressionValidator1" runat="server" ControlToValidate="TextBox1" ErrorMessage="RegularExpressionValidator" ValidationExpression="\d{5}">Enter 5 digits</asp:RegularExpressionValidator>

Protected Sub Page_Load(sender As Object, e As System.EventArgs)
            FpSpread1.NonEditModeValidation = True
            Dim tcell1 As New FarPoint.Web.Spread.TextCellType()
            tcell1.Validators.Add(RegularExpressionValidator1)
            FpSpread1.ActiveSheetView.Columns(1).CellType = tcell1
            FpSpread1.ActiveSheetView.Columns(1).BackColor = System.Drawing.Color.AliceBlue
            FpSpread1.ValidationErrorMessage = "test"
End Sub

Requirements

Target Platforms: Windows 7, Windows 8, Windows 10, Windows Vista, Windows Server 2003, Windows Server 2008, Windows Server 2012, Windows XP Professional

Reference

FpSpread Class
FpSpread Members