Tests to see if the value is valid for a cell in the active sheet in the Spread component.
Syntax
| Visual Basic (Usage) |  Copy Code |
|---|
Dim instance As FpSpread
Dim value As Object
Dim row As Integer
Dim column As Integer
Dim value As String
value = instance.Validate(value, row, column) |
Parameters
- value
- Value to validate
- row
- Row index of the cell
- column
- Column index of the cell
Return Value
String containing the reason the value is not valid, or null if it is valid
Remarks
Example
This example creates a column of Currency cells, sets a value in the first cell, then checks whether the value is valid and returns the result to a text box.
| C# | Copy Code |
|---|
PrivatevoidPage_Load(objectsender,System.EventArgse)
{
If(this.IsPostBack)Return;
FpSpread1.ActiveSheetView.Columns[0].CellType=NewFarPoint.Web.Spread.CurrencyCellType();
FpSpread1.ActiveSheetView.SetValue(0,0,108.89);
}
PrivatevoidButton1_Click(objectsender,System.EventArgse)
{
objectval=FpSpread1.ActiveSheetView.Cells[0,0].Value;
stringreason;
reason=FpSpread1.Validate(val,0,0);
If(reason==null||reason==String.Empty){
TextBox1.Text="Valid";
}Else{
TextBox1.Text=reason;
}
} |
| Visual Basic | Copy Code |
|---|
PrivateSubPage_Load(ByValsenderAsSystem.Object,ByValeAsSystem.EventArgs)HandlesMyBase.Load
If(Me.IsPostBack)ThenReturn
FpSpread1.ActiveSheetView.Columns(0).CellType=NewFarPoint.Web.Spread.CurrencyCellType()
FpSpread1.ActiveSheetView.SetValue(0,0,108.89)
EndSub
PrivateSubButton1_Click(ByValsenderAsSystem.Object,ByValeAsSystem.EventArgs)HandlesButton1.Click
DimvalAsObject=FpSpread1.ActiveSheetView.Cells[0,0].Value
DimreasonAsString
reason=FpSpread1.Validate(val,0,0)
If(reason=NothingOrreason=String.Empty)Then
TextBox1.Text="Valid"
Else
TextBox1.Text=reason
EndIf
EndSub |
Requirements
Target Platforms: Windows 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family, Windows Vista, Windows Server 2008 family
See Also
