Gets the formula, as a string, in the cell at the specified row and column.
Syntax
Parameters
- row
- Row index
- column
- Column index
Return Value
String containing the formula
Example
C# | Copy Code |
---|
FarPoint.Web.Spread.Model.IExpressionSupport ems;
ems = (FarPoint.Web.Spread.Model.IExpressionSupport)FpSpread1.ActiveSheetView.DataModel;
FpSpread1.ActiveSheetView.SetValue(0, 0, 5);
FpSpread1.ActiveSheetView.SetValue(1, 0, 5);
ems.SetFormula(2, 0, "SUM(A1, A2)");
Response.Write("The formula is " & ems.GetFormula(2, 0).ToString());
|
Visual Basic | Copy Code |
---|
Dim ems As FarPoint.Web.Spread.Model.IExpressionSupport
ems = FpSpread1.ActiveSheetView.DataModel
FpSpread1.ActiveSheetView.SetValue(0, 0, 5)
FpSpread1.ActiveSheetView.SetValue(1, 0, 5)
ems.SetFormula(2, 0, "SUM(A1, A2)")
Response.Write("The formula is " & ems.GetFormula(2, 0).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