Spread ASP.NET 14
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / SheetView Class / GetRowMerge Method
Row index
Example


In This Topic
    GetRowMerge Method
    In This Topic
    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