Determines whether the specified value can be converted to a decimal value and is between the minimum and maximum allowed value.

Syntax

Visual Basic (Declaration)
Public Overrides Function IsValid( _ ByVal value As Object _ ) As Boolean

Visual Basic (Usage)	Copy Code
Dim instance As CurrencyCellType Dim value As Object Dim value As Boolean value = instance.IsValid(value)

C#
public override bool IsValid( object value )

Parameters

value: Value to validate (as object)

Return Value

Boolean: true if the value can be converted to a decimal value and is between the minimum and maximum value; false otherwise

Remarks

The valid range of values is defined by the MinimumValue and MaximumValue 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.

C#	Copy Code
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());

Copy Code

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());

Visual Basic	Copy Code
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())

Visual Basic

Copy Code

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())

Requirements

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8