Spread for ASP.NET 11 Product Documentation
GetRowMerge Method
Example 


FarPoint.Web.Spread Assembly > FarPoint.Web.Spread Namespace > SheetView Class : GetRowMerge Method
Row index
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
'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());
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())
See Also

Reference

SheetView Class
SheetView Members
GetColumnMerge Method
SetRowMerge Method
Merging Cells Automatically