FarPoint.Web.Spread Assembly > FarPoint.Web.Spread.Model Namespace > DefaultSheetDataModel Class : EvaluateExpression Method |
'Declaration Public Function EvaluateExpression( _ ByVal row As Integer, _ ByVal column As Integer, _ ByVal expression As Expression _ ) As Object
'Usage Dim instance As DefaultSheetDataModel Dim row As Integer Dim column As Integer Dim expression As Expression Dim value As Object value = instance.EvaluateExpression(row, column, expression)
public object EvaluateExpression( int row, int column, Expression expression )
FarPoint.Web.Spread.Model.DefaultSheetDataModel dm; dm = FpSpread1.ActiveSheetView.DataModel; FarPoint.CalcEngine.Expression ex; object o; FpSpread1.ActiveSheetView.Cells[0, 0].Value = 10; FpSpread1.ActiveSheetView.Cells[1, 0].Value = 10; FpSpread1.ActiveSheetView.Cells[2, 0].Formula = "A1 + A2"; ex = dm.ParseFormula(2, 0, "A1+A2"); o = dm.EvaluateExpression(2, 0, ex); Response.Write(o.ToString());
Dim dm As FarPoint.Web.Spread.Model.DefaultSheetDataModel dm = FpSpread1.ActiveSheetView.DataModel Dim ex As FarPoint.CalcEngine.Expression Dim o As Object FpSpread1.ActiveSheetView.Cells(0, 0).Value = 10 FpSpread1.ActiveSheetView.Cells(1, 0).Value = 10 FpSpread1.ActiveSheetView.Cells(2, 0).Formula = "A1 + A2" ex = dm.ParseFormula(2, 0, "A1+A2") o = dm.EvaluateExpression(2, 0, ex) Response.Write(o.ToString())
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