Spread for ASP.NET 7.0 Product Documentation
MinimumValue Property
See Also  Example Support Options
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 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

See Also

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.