Spread ASP.NET 17
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / FpSpread Class / Validate Method
Example


In This Topic
    Validate Method
    In This Topic
    Tests to see if the value is valid for a cell in the active sheet in the Spread component.
    Overload List
    OverloadDescription
    ValidateTests to see if the value is valid for a cell in the active sheet in the Spread component.  
    Remarks

    This method calls the ValidateEditorValue method.

    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.
    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;
}
}
    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
    See Also

    Reference

    FpSpread Class
    FpSpread Members