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