FarPoint.Win.Spread Assembly > FarPoint.Win.Spread.CellType Namespace > MultiColumnComboBoxCellType Class : IsValid Method |
'Usage Dim instance As MultiColumnComboBoxCellType Dim value As Object Dim value As Boolean value = instance.IsValid(value)
true if value in entry is valid; false otherwise
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())
Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8