Spread Windows Forms 17
GrapeCity.Spreadsheet Assembly / GrapeCity.Spreadsheet Namespace / Table Class / CreateFormula Method
The Worksheet that contains the formula.
An integer value indicates the row of cell that contains the formula.
An integer value indicates the column of cell that contains the formula.
A GrapeCity.CalcEngine.StructuredItemSpecifiers value indicates the referred area.


In This Topic
    CreateFormula Method
    In This Topic
    Gets the formula that represents the specified area in the table.
    Syntax
    '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)

    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.
    See Also