GetFormula(Int32,Int32,Expression,Boolean) Method

In This Topic

Gets the formula for the cell of the specified row and column of this sheet.

Syntax

Visual Basic
C#

'Declaration
 
Public Function GetFormula( _
   ByVal r As Integer, _
   ByVal c As Integer, _
   ByVal expression As Expression, _
   ByVal isA1 As Boolean _
) As String

'Usage
 
Dim instance As Worksheet
Dim r As Integer
Dim c As Integer
Dim expression As Expression
Dim isA1 As Boolean
Dim value As String
 
value = instance.GetFormula(r, c, expression, isA1)

public string GetFormula( 
   int r,
   int c,
   Expression expression,
   bool isA1
)

Parameters

r: An integer value indicates the row index of cell.
c: An integer value indicates the column index of cell.
expression: The expression to unparse.
isA1: true to get A1 reference style formula; otherwise, false.

Return Value

The formula value of the cell.

Reference

Worksheet Class
Worksheet Members