Spread ASP.NET 14
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / SheetView Class / SetRowMerge Method
Row index
MergePolicy enumeration setting
Example


In This Topic
    SetRowMerge Method
    In This Topic
    Sets 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 Sub SetRowMerge( _
       ByVal row As Integer, _
       ByVal value As MergePolicy _
    ) 
    'Usage
     
    Dim instance As SheetView
    Dim row As Integer
    Dim value As MergePolicy
     
    instance.SetRowMerge(row, value)
    public void SetRowMerge( 
       int row,
       MergePolicy value
    )

    Parameters

    row
    Row index
    value
    MergePolicy enumeration setting
    Remarks
    The MergePolicy setting specifies if and how cells in this row are automatically merged.
    Example
    This example merges all cells in a row that contain the same data.
    FpSpread1.ActiveSheetView.Cells[0, 0, 0, 3].Text = "Test";
    FpSpread1.ActiveSheetView.SetRowMerge(0, FarPoint.Web.Spread.Model.MergePolicy.Always);
    
    FpSpread1.ActiveSheetView.Cells(0, 0, 0, 3).Text = "Test"
    FpSpread1.ActiveSheetView.SetRowMerge(0, FarPoint.Web.Spread.Model.MergePolicy.Always)
    See Also