Spread for ASP.NET 8.0 Product Documentation
UnparseFormula Method (DefaultSheetDataModel)
Example 


Gets the formula, as a string value, from the specified expression for the cell at the specified row and column.
Overload List
OverloadDescription
UnparseFormulaGets the formula, as a string value, from the specified expression for the cell at the specified row and column.  
Example
This example unparses a formula.
FarPoint.Web.Spread.Model.DefaultSheetDataModel dm;
dm = 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 = dm.ParseFormula(2, 0, "A1+A2"); 
s = dm.UnparseFormula(2, 0, ex); Response.Write(s);
Dim dm As FarPoint.Web.Spread.Model.DefaultSheetDataModel
dm = 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 = dm.ParseFormula(2, 0, "A1+A2") 
s = dm.UnparseFormula(2, 0, ex)
Response.Write(s) 
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

DefaultSheetDataModel Class
DefaultSheetDataModel Members
ParseFormula Method

 

 


Copyright © GrapeCity, inc. All rights reserved.