SetRowMerge Method

Sets whether or how cells in a row on this sheet that have the same content are joined into a single cell across multiple columns.

Syntax

Visual Basic
C#

'Declaration
 
Public Sub SetRowMerge( _
   ByVal row As Integer, _
   ByVal value As MergePolicy _
)

'Usage
 
Dim instance As SheetView
Dim row As Integer
Dim value As MergePolicy
 
instance.SetRowMerge(row, value)

public void SetRowMerge( 
   int row,
   MergePolicy value
)

Parameters

row: Row index
value: MergePolicy enumeration setting

Remarks

The MergePolicy setting specifies if and how cells in this row are automatically merged.

Example

This example merges all cells in a row that contain the same data.

FpSpread1.ActiveSheetView.Cells[0, 0, 0, 3].Text = "Test";
FpSpread1.ActiveSheetView.SetRowMerge(0, FarPoint.Web.Spread.Model.MergePolicy.Always);

Visual Basic

FpSpread1.ActiveSheetView.Cells(0, 0, 0, 3).Text = "Test"
FpSpread1.ActiveSheetView.SetRowMerge(0, FarPoint.Web.Spread.Model.MergePolicy.Always)

Requirements

Target Platforms: Windows 7, Windows 8, Windows Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6

Reference

SheetView Class
SheetView Members
GetRowMerge Method
SetColumnMerge Method

User-Task Documentation

Merging Cells Automatically