Spread WinForms 15
GrapeCity.Spreadsheet Assembly / GrapeCity.Spreadsheet Namespace / LayoutManager Class / Merge 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.
if set to true, merge cells in each row (or column) of the specified range as separate merged cells.
if set to true, cells are merged by rows; otherwise, cells are merged by columns. It has effect only if across is true.
if set to true, intersected merged cells will be removed; otherwise, they'll be unioned.
if set to true, all overlapped cell will be clear.


In This Topic
Merge Method (LayoutManager)
In This Topic
Creates a merged cell from the specified cell range.
Syntax
'Declaration
 
Public Function Merge( _
   ByVal row As Integer, _
   ByVal column As Integer, _
   ByVal row2 As Integer, _
   ByVal column2 As Integer, _
   Optional ByVal across As Boolean, _
   Optional ByVal vertical As Boolean, _
   Optional ByVal replace As Boolean, _
   Optional ByVal clearCellValue As Boolean _
) As ActionResult(Of Worksheet)
 
'Usage
 
Dim instance As LayoutManager
Dim row As Integer
Dim column As Integer
Dim row2 As Integer
Dim column2 As Integer
Dim across As Boolean
Dim vertical As Boolean
Dim replace As Boolean
Dim clearCellValue As Boolean
Dim value As ActionResult(Of Worksheet)
 
value = instance.Merge(row, column, row2, column2, across, vertical, replace, clearCellValue)

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.
across
if set to true, merge cells in each row (or column) of the specified range as separate merged cells.
vertical
if set to true, cells are merged by rows; otherwise, cells are merged by columns. It has effect only if across is true.
replace
if set to true, intersected merged cells will be removed; otherwise, they'll be unioned.
clearCellValue
if set to true, all overlapped cell will be clear.

Return Value

An ActionResult<T> value represents the action result.
See Also