'Declaration
 
Public Function CreateFormula( _
   ByVal contextSheet As Worksheet, _
   ByVal contextRow As Integer, _
   ByVal contextColumn As Integer, _
   ByVal itemSpecifiers As StructuredItemSpecifiers, _
   Optional ByVal column1 As Integer, _
   Optional ByVal column2 As Integer, _
   Optional ByVal isA1Reference As Boolean _
) As String

'Usage
 
Dim instance As Table
Dim contextSheet As Worksheet
Dim contextRow As Integer
Dim contextColumn As Integer
Dim itemSpecifiers As StructuredItemSpecifiers
Dim column1 As Integer
Dim column2 As Integer
Dim isA1Reference As Boolean
Dim value As String
 
value = instance.CreateFormula(contextSheet, contextRow, contextColumn, itemSpecifiers, column1, column2, isA1Reference)

public string CreateFormula( 
   Worksheet contextSheet,
   int contextRow,
   int contextColumn,
   StructuredItemSpecifiers itemSpecifiers,
   int column1,
   int column2,
   bool isA1Reference
)

Parameters

contextSheet

The Worksheet that contains the formula.

contextRow

An integer value indicates the row of cell that contains the formula.

contextColumn

An integer value indicates the column of cell that contains the formula.

itemSpecifiers

A GrapeCity.CalcEngine.StructuredItemSpecifiers value indicates the referred area.

column1

column2

isA1Reference

Return Value

Reference

Table Class
Table Members