Gets the formula, as a string 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
String containing the formula
Remarks
Example
This example illustrates the use of this member by returning the formula (as a string) for the specified row and column.
C# | Copy Code |
---|
FarPoint.Win.Spread.Model.DefaultSheetDataModel dataModel = new FarPoint.Win.Spread.Model.DefaultSheetDataModel(5, 5);
object o;
fpSpread1.ActiveSheet.Models.Data = dataModel;
dataModel.SetValue(0, 0, 10);
dataModel.SetValue(1, 0, 20);
dataModel.SetFormula(0, 0, "3*SUM(A1, A2)");
o = dataModel.GetFormula(0, 0);
listBox1.Items.Add(o.ToString()); |
Visual Basic | Copy Code |
---|
Dim dataModel As New FarPoint.Win.Spread.Model.DefaultSheetDataModel(5, 5)
Dim o As Object
FpSpread1.ActiveSheet.Models.Data = dataModel
dataModel.SetValue(0, 0, 10)
dataModel.SetValue(1, 0, 20)
dataModel.SetFormula(0, 0, "3*SUM(A1, A2)")
o = dataModel.GetFormula(0, 0)
ListBox1.Items.Add(o.ToString()) |
Requirements
Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8
See Also