Spread Windows Forms 12.0 Product Documentation
Evaluate(String,IWorksheet,CellReference) Method


GrapeCity.Spreadsheet Assembly > GrapeCity.Spreadsheet Namespace > CalculationEngine Class : Evaluate(String,IWorksheet,CellReference) Method
An string value indicates the formula to evaluate.
An IWorksheet object indicates the context worksheet.
A CellReference value indicates the context cell.
Evaluates the specified expression using the specified evaluation context.
Syntax
'Declaration
 
Public Function Evaluate( _
   ByVal formula As String, _
   ByVal worksheet As IWorksheet, _
   ByVal contextCell As CellReference _
) As IValue
'Usage
 
Dim instance As CalculationEngine
Dim formula As String
Dim worksheet As IWorksheet
Dim contextCell As CellReference
Dim value As IValue
 
value = instance.Evaluate(formula, worksheet, contextCell)
public IValue Evaluate( 
   string formula,
   IWorksheet worksheet,
   CellReference contextCell
)

Parameters

formula
An string value indicates the formula to evaluate.
worksheet
An IWorksheet object indicates the context worksheet.
contextCell
A CellReference value indicates the context cell.

Return Value

GrapeCity.CalcEngine.IValue.
See Also

Reference

CalculationEngine Class
CalculationEngine Members