Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread Namespace / RegularExpressionValidator Class / Expression Property
Example


In This Topic
    Expression Property
    In This Topic
    Gets or sets a regular expression that is matched by the specified value.
    Syntax
    'Declaration
     
    Public Property Expression As String
    'Usage
     
    Dim instance As RegularExpressionValidator
    Dim value As String
     
    instance.Expression = value
     
    value = instance.Expression
    public string Expression {get; set;}

    Property Value

    A System.String value that represents a regular expression that is matched by the specified value. The default is String.Empty.
    Example
    This example uses the regular expression validator.
    //The error backcolor is displayed if the value is invalid
    FarPoint.Win.Spread.CellStyleNotify cnotify = new FarPoint.Win.Spread.CellStyleNotify();
    cnotify.InvalidCellStyle.BackColor = Color.Lime;
    FarPoint.Win.Spread.RegularExpressionValidator rvalidator = new FarPoint.Win.Spread.RegularExpressionValidator();
    rvalidator.Expression = "AA";
    rvalidator.RegexOptions = System.Text.RegularExpressions.RegexOptions.IgnoreCase;
    rvalidator.NullIsValid = true;
    rvalidator.Actions.Add(cnotify);
    fpSpread1.Sheets[0].AddValidators(new FarPoint.Win.Spread.Model.CellRange(1, 1, 1, 1), rvalidator);
    'The error backcolor is displayed if the value is invalid
    Dim cnotify As New FarPoint.Win.Spread.CellStyleNotify()
    cnotify.InvalidCellStyle.BackColor = Color.Lime
    Dim rvalidator As New FarPoint.Win.Spread.RegularExpressionValidator()
    rvalidator.Expression = "AA"
    rvalidator.RegexOptions = System.Text.RegularExpressions.RegexOptions.IgnoreCase
    rvalidator.NullIsValid = True
    rvalidator.Actions.Add(cnotify)
    FpSpread1.Sheets(0).AddValidators(New FarPoint.Win.Spread.Model.CellRange(1, 1, 1, 1), rvalidator)
    See Also