Spread ASP.NET 15
FarPoint.Web.Spread.Extender Assembly / FarPoint.Web.Spread.Extender Namespace / MaskedEditValidator Class / MaskedEditValidator Constructor
Example


In This Topic
    MaskedEditValidator Constructor
    In This Topic
    Syntax
    'Declaration
     
    Public Function New()
    'Usage
     
    Dim instance As New MaskedEditValidator()
    public MaskedEditValidator()
    Example
    This example uses a masked edit validator.
    FarPoint.Web.Spread.Extender.MaskedEditCellType m = new FarPoint.Web.Spread.Extender.MaskedEditCellType();
    m.ShowEditor = true;
    m.MaskType = AjaxControlToolkit.MaskedEditType.Number;
    m.Mask = "9,999";
        
    FarPoint.Web.Spread.Extender.MaskedEditValidator mv = new FarPoint.Web.Spread.Extender.MaskedEditValidator();
    mv.MaximumValue = "999";
    mv.MinimumValue = "100";
    mv.InvalidValueMessage = "Type a number.";
    m.MaskedEditValidator = mv;
    FpSpread1.Sheets[0].Cells[0, 0].CellType = m;
        
    FarPoint.Web.Spread.Extender.DateCalendarCellType dc = new FarPoint.Web.Spread.Extender.DateCalendarCellType();
    dc.DateFormat = "yyyy/MM/dd";
    AjaxControlToolkit.MaskedEditExtender mee = new AjaxControlToolkit.MaskedEditExtender();
    mee.Mask = "9999/99/99";
    mee.MaskType = AjaxControlToolkit.MaskedEditType.Date;
    mee.ErrorTooltipEnabled = true;
    //Add Extender to CellType
    dc.Extenders.Add(mee);
    dc.ShowEditor = true;
    //Configure validator
    FarPoint.Web.Spread.Extender.MaskedEditValidator mv1 = new FarPoint.Web.Spread.Extender.MaskedEditValidator();
    mv1.MaximumValue = "2010/12/31";
    mv1.MinimumValue = "2000/01/01";
    mv1.InvalidValueMessage = "Please type a date.";
    //Set Validator
    dc.MaskedEditValidator = mv1;
    FpSpread1.Sheets[0].Cells[1, 0].CellType = dc;
    
    
    Dim m As New FarPoint.Web.Spread.Extender.MaskedEditCellType
    m.ShowEditor = True
    m.MaskType = AjaxControlToolkit.MaskedEditType.Number
    m.Mask = "9,999"
    
    Dim mv As New FarPoint.Web.Spread.Extender.MaskedEditValidator
    mv.MaximumValue = "999"
    mv.MinimumValue = "100"
    mv.InvalidValueMessage = "Type a number."
    m.MaskedEditValidator = mv
    FpSpread1.Sheets(0).Cells(0, 0).CellType = m
    
    Dim dc As New FarPoint.Web.Spread.Extender.DateCalendarCellType
    dc.DateFormat = "yyyy/MM/dd"
    Dim mee As New AjaxControlToolkit.MaskedEditExtender
    mee.Mask = "9999/99/99"
    mee.MaskType = AjaxControlToolkit.MaskedEditType.Date
    mee.ErrorTooltipEnabled = True
    'Add Extender to CellType
    dc.Extenders.Add(mee)
    dc.ShowEditor = True
    'Configure validator
    Dim mv1 As New FarPoint.Web.Spread.Extender.MaskedEditValidator
    mv1.MaximumValue = "2010/12/31"
    mv1.MinimumValue = "2000/01/01"
    mv1.InvalidValueMessage = "Please type a date."
    'Set Validator
    dc.MaskedEditValidator = mv1
    FpSpread1.Sheets(0).Cells(1, 0).CellType = dc
    
    See Also