'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
The formula that represents the specified area in the table.