Spread Windows Forms 13.0 Product Documentation
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)
    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.
    Requirements

    Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows Server 2012 R2, Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows 10

    See Also