FarPoint.Web.Spread Assembly > FarPoint.Web.Spread.Model Namespace > IExpressionSupport2 Interface : UnparseFormula Method |
'Declaration Function UnparseFormula( _ ByVal row As Integer, _ ByVal column As Integer, _ ByVal expression As Expression _ ) As String
'Usage Dim instance As IExpressionSupport2 Dim row As Integer Dim column As Integer Dim expression As Expression Dim value As String value = instance.UnparseFormula(row, column, expression)
string UnparseFormula( int row, int column, Expression expression )
FarPoint.Web.Spread.Model.IExpressionSupport2 es; es = FpSpread1.ActiveSheetView.DataModel; FarPoint.CalcEngine.Expression ex; string s; 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"); s = es.UnparseFormula(2, 0, ex); Response.Write(s);
Dim es As FarPoint.Web.Spread.Model.IExpressionSupport2 es = FpSpread1.ActiveSheetView.DataModel Dim ex As FarPoint.CalcEngine.Expression Dim s As String 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") s = es.UnparseFormula(2, 0, ex) Response.Write(s)
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