Parses the string value and returns the expression for the cell at the specified row and column.

Syntax

Visual Basic (Declaration)
Function ParseFormula( _ ByVal row As Integer, _ ByVal column As Integer, _ ByVal value As String _ ) As Expression

Visual Basic (Usage)	Copy Code
Dim instance As IExpressionSupport2 Dim row As Integer Dim column As Integer Dim value As String Dim value As Expression value = instance.ParseFormula(row, column, value)

C#
Expression ParseFormula( int row, int column, string value )

Parameters

row: Row index of the cell
column: Column index of the cell
value: Formula to be parsed to a string

Return Value

Expression containing the parsed formula

Exceptions

Exception	Description
ParseException	Value is not a valid formula.

Example

This example parses a formula.

C#	Copy Code
FarPoint.Web.Spread.Model.IExpressionSupport2 es; es = FpSpread1.ActiveSheetView.DataModel; FarPoint.CalcEngine.Expression ex; FpSpread1.ActiveSheetView.Cells[0, 0].Value = 10; FpSpread1.ActiveSheetView.Cells[1, 0].Value = 10; FpSpread1.ActiveSheetView.Cells[2, 0].Formula = "A1 + A2"; ex = es.ParseFormula(2, 0, "A1+A2"); Response.Write(ex.ToString());

Copy Code

FarPoint.Web.Spread.Model.IExpressionSupport2 es;
es = FpSpread1.ActiveSheetView.DataModel;
FarPoint.CalcEngine.Expression ex; FpSpread1.ActiveSheetView.Cells[0, 0].Value = 10; 
FpSpread1.ActiveSheetView.Cells[1, 0].Value = 10; 
FpSpread1.ActiveSheetView.Cells[2, 0].Formula = "A1 + A2"; 
ex = es.ParseFormula(2, 0, "A1+A2"); 
Response.Write(ex.ToString());

Visual Basic	Copy Code
Dim es As FarPoint.Web.Spread.Model.IExpressionSupport2 es = FpSpread1.ActiveSheetView.DataModel Dim ex As FarPoint.CalcEngine.Expression FpSpread1.ActiveSheetView.Cells(0, 0).Value = 10 FpSpread1.ActiveSheetView.Cells(1, 0).Value = 10 FpSpread1.ActiveSheetView.Cells(2, 0).Formula = "A1 + A2" ex = es.ParseFormula(2, 0, "A1+A2") Response.Write(ex.ToString())

Visual Basic

Copy Code

Dim es As FarPoint.Web.Spread.Model.IExpressionSupport2
es = FpSpread1.ActiveSheetView.DataModel
Dim ex As FarPoint.CalcEngine.Expression FpSpread1.ActiveSheetView.Cells(0, 0).Value = 10 
FpSpread1.ActiveSheetView.Cells(1, 0).Value = 10 
FpSpread1.ActiveSheetView.Cells(2, 0).Formula = "A1 + A2" 
ex = es.ParseFormula(2, 0, "A1+A2")
Response.Write(ex.ToString())

Requirements

Target Platforms: Windows 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family, Windows Vista, Windows Server 2008 family