Spread ASP.NET 6.0 Product Documentation
MinimumValue Property
See Also  Example Send Feedback
FarPoint.Web.Spread.Extender Assembly > FarPoint.Web.Spread.Extender Namespace > MaskedEditValidator Class : MinimumValue Property


Glossary Item Box

Gets or sets the minimum value.

Syntax

Visual Basic (Declaration) 
Public Property MinimumValue As String
Visual Basic (Usage)Copy Code
Dim instance As MaskedEditValidator
Dim value As String
 
instance.MinimumValue = value
 
value = instance.MinimumValue
C# 
public string MinimumValue {get; set;}

Property Value

The minimum value.

Example

This example sets the MinimumValue property.
C#Copy Code
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;

Visual BasicCopy Code
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

Requirements

Target Platforms: Windows 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family, Windows Vista, Windows Server 2008 family

See Also

© 2002-2012 GrapeCity, Inc. All Rights Reserved.