Syntax
| Visual Basic (Declaration) | |
|---|---|
Public Function GetExpression( _ ByVal row As Integer, _ ByVal column As Integer _ ) As Expression | |
| Visual Basic (Usage) |  Copy Code |
|---|---|
Dim instance As SheetView Dim row As Integer Dim column As Integer Dim value As Expression value = instance.GetExpression(row, column) | |
| C# | |
|---|---|
public Expression GetExpression( int row, int column ) | |
Parameters
- row
- Row index of the cell
- column
- Column index of the cell
Return Value
Expression containing the formulaExceptions
| Exception | Description |
|---|---|
| System.ArgumentOutOfRangeException | Specified row index is out of range; must be between 0 and the total number of rows |
| System.ArgumentOutOfRangeException | Specified column index is out of range; must be between 0 and the total number of columns |
Example
This example sets an expression into the specified cell.
| C# | Copy Code |
|---|---|
FarPoint.CalcEngine.Expression one; FarPoint.CalcEngine.Expression two; FarPoint.CalcEngine.Expression oneplustwo; 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); fpSpread1.ActiveSheet.SetExpression(0, 0, oneplustwo); FarPoint.CalcEngine.Expression x; x = fpSpread1.ActiveSheet.GetExpression(0, 0); MessageBox.Show(x.ToString()); | |
| Visual Basic | Copy Code |
|---|---|
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) FpSpread1.ActiveSheet.SetExpression(0, 0, oneplustwo) Dim x As FarPoint.CalcEngine.Expression x = FpSpread1.ActiveSheet.GetExpression(0, 0) MessageBox.Show(x.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