GetRowMerge Method

Gets 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 Function GetRowMerge( _
   ByVal row As Integer _
) As MergePolicy

'Usage
 
Dim instance As SheetView
Dim row As Integer
Dim value As MergePolicy
 
value = instance.GetRowMerge(row)

public MergePolicy GetRowMerge( 
   int row
)

Parameters

row: Row index

Return Value

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

Example

This example returns the merge policy for the model.

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

FarPoint.Web.Spread.Model.MergePolicy mp;
mp = FpSpread1.ActiveSheetView.GetRowMerge(0);
Response.Write(mp.ToString());

Visual Basic

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

Dim mp As FarPoint.Web.Spread.Model.MergePolicy
mp = FpSpread1.ActiveSheetView.GetRowMerge(0)
Response.Write(mp.ToString())

Requirements

Target Platforms: Windows 7, Windows 8, Windows 10, Windows Vista, Windows Server 2003, Windows Server 2008, Windows Server 2012, Windows XP Professional

Reference

SheetView Class
SheetView Members
GetColumnMerge Method
SetRowMerge Method
Merging Cells Automatically