Spread for ASP.NET 8.0 Product Documentation
Validate Method
Example 


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
Requirements

Target Platforms: Windows 7, Windows 8, Windows Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6

See Also

Reference

FpSpread Class
FpSpread Members

 

 


Copyright © GrapeCity, inc. All rights reserved.