Spread Windows Forms 15.0
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.


In This Topic
    Evaluate(String,IWorksheet,CellReference) Method
    In This Topic
    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)

    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