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())

Reference

SheetView Class
SheetView Members
GetColumnMerge Method
SetRowMerge Method
Merging Cells Automatically