GetMergeCell メソッド

Visual Basic
C#

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

public CellRange GetMergeCell( 
   int row,
   int column
)

パラメータ

row: セルの行インデックス
column: セルの列インデックス

戻り値の型

セル範囲を含むCellRangeオブジェクト

次のサンプルコードは、フォーカス矩形の境界線スタイルを設定します。

C#
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 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 + "')");
}

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

FpSpread クラス
 FpSpread メンバ
 GetMergeCellsメソッド

開発者の手引き

セルの自動マージ