Spread WinForms 15
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