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.UserDateFormat = AjaxControlToolkit.MaskedEditUserDateFormat.YearMonthDay;
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.UserDateFormat = AjaxControlToolkit.MaskedEditUserDateFormat.YearMonthDay
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