Spread Windows Forms 12.0 Product Documentation
IsValid Method (DateTimeCellType)

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


Value to validate (as object)

Return Value

Boolean: true if the value can be converted to a Date-Time object and is between the minimum and maximum allowed values; false otherwise
The valid range of values is defined by the MinimumDate, MinimumTime, MaximumDate, and MaximumTime properties.
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);
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)
See Also


DateTimeCellType Class
DateTimeCellType Members
MaximumDate Property
MaximumTime Property
MinimumDate Property
MinimumTime Property