Gets the formula, as an expression value, for the cell of the specified row and column.
Syntax
Parameters
- row
- Row index of the cell
- column
- Column index of the cell
Return Value
Expression containing the formula
Remarks
Example
This example returns the formula, as an expression value, for the cell of the specified row and column.
C# | Copy Code |
---|
FarPoint.CalcEngine.Expression one;
FarPoint.CalcEngine.Expression two;
FarPoint.CalcEngine.Expression oneplustwo;
FarPoint.Web.Spread.Model.DefaultSheetDataModel dataModel;
one = new FarPoint.CalcEngine.DoubleExpression(100);
two = new FarPoint.CalcEngine.DoubleExpression(20);
oneplustwo = new FarPoint.CalcEngine.BinaryOperatorExpression(FarPoint.CalcEngine.BinaryOperatorInfo.AddOperator, one, two);
dataModel = (FarPoint.Web.Spread.Model.DefaultSheetDataModel)FpSpread1.ActiveSheetView.DataModel;
dataModel.SetExpression(0, 0, oneplustwo);
FarPoint.CalcEngine.Expression x;
x = dataModel.GetExpression(0, 0);
Response.Write(x.ToString());
|
Visual Basic | Copy Code |
---|
Dim dfltdatamodel As FarPoint.Web.Spread.Model.DefaultSheetDataModel
Dim one As FarPoint.CalcEngine.Expression
Dim two As FarPoint.CalcEngine.Expression
Dim oneplustwo As FarPoint.CalcEngine.Expression
one = New FarPoint.CalcEngine.DoubleExpression(100.0)
two = New FarPoint.CalcEngine.DoubleExpression(20.0)
oneplustwo = New FarPoint.CalcEngine.BinaryOperatorExpression(FarPoint.CalcEngine.BinaryOperatorInfo.AddOperator, one, two)
dfltdatamodel = FpSpread1.ActiveSheetView.DataModel
dfltdatamodel.SetExpression(0, 0, oneplustwo)
Dim x As FarPoint.CalcEngine.Expression
x = dfltdatamodel.GetExpression(0, 0)
Response.Write(x.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
See Also