Spread Windows Forms 17
GrapeCity.Spreadsheet Assembly / GrapeCity.Spreadsheet Namespace / Worksheet Class / SetFormula 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.
if set to true, the change will be notified.


In This Topic
    SetFormula Method (Worksheet)
    In This Topic
    Sets the formula text for the cell of the specified cell range.
    Syntax
    'Declaration
     
    
    Public Function SetFormula( _
       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, _
       Optional ByVal notify 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 notify As Boolean
    Dim value As ActionResult(Of Object)
     
    value = instance.SetFormula(row, column, row2, column2, formula, autoFormatting, notify)

    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.
    notify
    if set to true, the change will be notified.

    Return Value

    The details data of the action result.
    See Also