Spread WinForms 15
GrapeCity.Spreadsheet Assembly / GrapeCity.Spreadsheet Namespace / Worksheet Class / SetExpression(Int32,Int32,Int32,Int32,Expression,Boolean,Boolean) 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.
An GrapeCity.CalcEngine.Expression value 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
SetExpression(Int32,Int32,Int32,Int32,Expression,Boolean,Boolean) Method
In This Topic
Sets the GrapeCity.CalcEngine.Expression value for the cell of the specified cell range.
Syntax
'Declaration
 
Public Function SetExpression( _
   ByVal row As Integer, _
   ByVal column As Integer, _
   ByVal row2 As Integer, _
   ByVal column2 As Integer, _
   ByVal expression As Expression, _
   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 expression As Expression
Dim autoFormatting As Boolean
Dim notify As Boolean
Dim value As ActionResult(Of Object)
 
value = instance.SetExpression(row, column, row2, column2, expression, 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.
expression
An GrapeCity.CalcEngine.Expression value 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