Spread Windows Forms 17
GrapeCity.Spreadsheet Assembly / GrapeCity.Spreadsheet Namespace / Worksheet Class / SetFormulaArray Method
An integer value indicates the top row index of cell range.
An integer value indicates the left column index of cell range.
An integer value indicates the bottom row index of cell range.
An integer value indicates the right column index of cell range.
A string value indicates the formula text to set
A boolean value indicates that the cell may be auto formatted by some special functions.


In This Topic
    SetFormulaArray Method
    In This Topic
    Sets the formula text for the cell of the specified cell range.
    Syntax
    'Declaration
     
    
    Public Function SetFormulaArray( _
       ByVal row As Integer, _
       ByVal column As Integer, _
       ByVal row2 As Integer, _
       ByVal column2 As Integer, _
       ByVal formula As String, _
       Optional ByVal autoFormatting As Boolean _
    ) As ActionResult(Of Object)
    'Usage
     
    
    Dim instance As Worksheet
    Dim row As Integer
    Dim column As Integer
    Dim row2 As Integer
    Dim column2 As Integer
    Dim formula As String
    Dim autoFormatting As Boolean
    Dim value As ActionResult(Of Object)
     
    value = instance.SetFormulaArray(row, column, row2, column2, formula, autoFormatting)

    Parameters

    row
    An integer value indicates the top row index of cell range.
    column
    An integer value indicates the left column index of cell range.
    row2
    An integer value indicates the bottom row index of cell range.
    column2
    An integer value indicates the right column index of cell range.
    formula
    A string value indicates the formula text to set
    autoFormatting
    A boolean value indicates that the cell may be auto formatted by some special functions.

    Return Value

    The details data of the action result.
    See Also