Spread Windows Forms 12.0 Product Documentation
IsValid Method (SliderCellType)
Example 


FarPoint.Win.Spread Assembly > FarPoint.Win.Spread.CellType Namespace > SliderCellType Class : IsValid Method
Value to validate (as object)
Determines whether the specified value can be converted to an integer value and is between the minimum and maximum allowed values.
Syntax
'Declaration
 
Public Overrides Function IsValid( _
   ByVal value As Object _
) As Boolean
'Usage
 
Dim instance As SliderCellType
Dim value As Object
Dim value As Boolean
 
value = instance.IsValid(value)
public override bool IsValid( 
   object value
)

Parameters

value
Value to validate (as object)

Return Value

Boolean: true if the value can be converted to an integer value and is between the minimum and maximum value; false otherwise
Remarks
The valid range of values is defined by the Minimum and Maximum properties.
Example
This example shows the use of the IsValid method for a date-time formatted numeric cell type, but it can be used for other cell types as well.
FarPoint.Win.Spread.CellType.DateTimeCellType dt = new FarPoint.Win.Spread.CellType.DateTimeCellType();
bool b;
dt.DateTimeFormat = FarPoint.Win.Spread.CellType.DateTimeFormat.ShortDate;
dt.MaximumDate = new System.DateTime(2010, 12, 31);
dt.MinimumDate = new System.DateTime(1990, 1, 1);
fpSpread1.ActiveSheet.Cells[0, 0].CellType = dt;
fpSpread1.ActiveSheet.Cells[0, 0].Value = new System.DateTime(2011, 9, 12);
fpSpread1.ActiveSheet.Cells[1, 0].CellType = dt;
fpSpread1.ActiveSheet.Cells[1, 0].Value = new System.DateTime(1989, 9, 12);
b = dt.IsValid(fpSpread1.ActiveSheet.Cells[0, 0].Value);
listBox1.Items.Add(b.ToString());
Dim dt As New FarPoint.Win.Spread.CellType.DateTimeCellType()
Dim b As Boolean
dt.DateTimeFormat = FarPoint.Win.Spread.CellType.DateTimeFormat.ShortDate
dt.MaximumDate = New System.DateTime(2010, 12, 31)
dt.MinimumDate = New System.DateTime(1990, 1, 1)
fpSpread1.ActiveSheet.Cells(0, 0).CellType = dt
fpSpread1.ActiveSheet.Cells(0, 0).Value = New System.DateTime(2011, 9, 12)
fpSpread1.ActiveSheet.Cells(1, 0).CellType = dt
fpSpread1.ActiveSheet.Cells(1, 0).Value = New System.DateTime(1989, 9, 12)
b = dt.IsValid(fpSpread1.ActiveSheet.Cells(0, 0).Value)
ListBox1.Items.Add(b.ToString())
See Also

Reference

SliderCellType Class
SliderCellType Members
Maximum Property
Minimum Property