Syntax
| Visual Basic (Declaration) | |
|---|---|
Public Overridable Function GetExpression( _ ByVal row As Integer, _ ByVal column As Integer _ ) As Expression | |
| Visual Basic (Usage) |  Copy Code |
|---|---|
Dim instance As DefaultSheetDataModel Dim row As Integer Dim column As Integer Dim value As Expression value = instance.GetExpression(row, column) | |
| C# | |
|---|---|
public virtual Expression GetExpression( int row, int column ) | |
Parameters
- row
- Row index of the cell
- column
- Column index of the cell
Return Value
Expression containing the formulaRemarks
This method returns the formula as an expression; to return the formula as a string, refer to the GetFormula method.
For more information on formulas, refer to the Formula Reference.
Example
This example returns the formula (as an expression) 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 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2