Gets the merged cell range at the specified cell.
Syntax
Visual Basic (Usage) | Copy Code |
---|
Dim instance As FpSpread
Dim row As Integer
Dim column As Integer
Dim value As CellRange
value = instance.GetMergeCell(row, column) |
Parameters
- row
- Row index of the cell
- column
- Column index of the cell
Return Value
CellRange object containing the range of cells
Example
This example sets the border style of the focus rectangle.
C# | Copy Code |
---|
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 | Copy Code |
---|
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 |
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
See Also