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
Exceptions
| 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 returns the set expression for the specified cell.This example returns the set expression for 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.ActiveSheetView.SetExpression(0, 0, oneplustwo); FarPoint.CalcEngine.Expression x; x = FpSpread1.ActiveSheetView.GetExpression(0, 0); string msg = x.ToString(); Response.Write("alert('" + msg + "')"); | |
| 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.ActiveSheetView.SetExpression(0, 0, oneplustwo) Dim x As FarPoint.CalcEngine.Expression x = FpSpread1.ActiveSheetView.GetExpression(0, 0) Dim msg As String = x.ToString() Response.Write("alert('" & msg & "')") | |
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