GetMergeCell Method

Visual Basic
C#

'Declaration
 
Public Function GetMergeCell( _
   ByVal row As Integer, _
   ByVal column As Integer _
) As CellRange

'Usage
 
Dim instance As FpSpread
Dim row As Integer
Dim column As Integer
Dim value As CellRange
 
value = instance.GetMergeCell(row, column)

public CellRange GetMergeCell( 
   int row,
   int column
)

Parameters

row: Row index of the cell
column: Column index of the cell

Return Value

CellRange object containing the range of cells

This example sets the border style of the focus rectangle.

C#

FpSpread1.ActiveSheetView.SetColumnMerge(0, FarPoint.Web.Spread.Model.MergePolicy.Always); 
FpSpread1.ActiveSheetView.Cells[0, 0].Text = "FarPoint"; 
FpSpread1.ActiveSheetView.Cells[1, 0].Text = "FarPoint"; 
FpSpread1.ActiveSheetView.Cells[2, 0].Text = "FarPoint";

protected override void Render(System.Web.UI.HtmlTextWriter writer) 
{ 
    FarPoint.Web.Spread.Model.CellRange cr; 
    cr = FpSpread1.GetMergeCell(0, 0); 
    string msg = "The merged cell is in column " + cr.Column; 
    Response.Write("alert('" + msg + "')");
}

Visual Basic

FpSpread1.ActiveSheetView.SetColumnMerge(0, FarPoint.Web.Spread.Model.MergePolicy.Always)
FpSpread1.ActiveSheetView.Cells(0, 0).Text = "FarPoint"
FpSpread1.ActiveSheetView.Cells(1, 0).Text = "FarPoint"
FpSpread1.ActiveSheetView.Cells(2, 0).Text = "FarPoint"

Protected Overrides Sub Render(ByVal writer As System.Web.UI.HtmlTextWriter)
    Dim cr As FarPoint.Web.Spread.Model.CellRange
    cr = FpSpread1.GetMergeCell(0, 0)

    Dim msg As String = "The merged cell is in column " & cr.Column
    Response.Write("alert('" & msg & "')")
End Sub

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

Reference

FpSpread Class
FpSpread Members
GetMergeCells Method

User-Task Documentation

Allowing Cells to Merge Automatically