Spread for ASP.NET 8.0 Product Documentation
ParseFormula Method (IExpressionSupport2)
Example 


Row index of the cell
Column index of the cell
Formula to be parsed to a string
Parses the string value and returns the expression for the cell at the specified row and column.
Syntax
'Declaration
 
Function ParseFormula( _
   ByVal row As Integer, _
   ByVal column As Integer, _
   ByVal value As String _
) As Expression
'Usage
 
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)
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
ExceptionDescription
ParseException Value is not a valid formula.
Example
This example parses a formula.
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());  
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 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

See Also

Reference

IExpressionSupport2 Interface
IExpressionSupport2 Members

 

 


Copyright © GrapeCity, inc. All rights reserved.