ValidationErrorMessage Property

Visual Basic
C#

'Declaration
 
Public Property ValidationErrorMessage As String

'Usage
 
Dim instance As FpSpread
Dim value As String
 
instance.ValidationErrorMessage = value
 
value = instance.ValidationErrorMessage

public string ValidationErrorMessage {get; set;}

This example displays an error message if the data is not valid.

C#

<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

Target Platforms: Windows 7, Windows 8, Windows Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6

Reference

FpSpread Class
FpSpread Members