Spread for ASP.NET 13 Product Documentation
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread.Model Namespace / DefaultSheetAxisModel Class / SetMergePolicy Method
Row or column index
Value with merge policy
Example


In This Topic
    SetMergePolicy Method (DefaultSheetAxisModel)
    In This Topic
    Sets the cell merge policy for the row or column.
    Syntax
    'Declaration
     
    Public Overrides Sub SetMergePolicy( _
       ByVal index As Integer, _
       ByVal value As MergePolicy _
    ) 
    'Usage
     
    Dim instance As DefaultSheetAxisModel
    Dim index As Integer
    Dim value As MergePolicy
     
    instance.SetMergePolicy(index, value)
    public override void SetMergePolicy( 
       int index,
       MergePolicy value
    )

    Parameters

    index
    Row or column index
    value
    Value with merge policy
    Remarks
    The MergePolicy setting specifies if and how cells in this column are automatically merged.
    Example
    This example merges all cells that contain the same data.
    FarPoint.Web.Spread.Model.ISheetAxisModel dsa;
    dsa = FpSpread1.ActiveSheetView.ColumnAxisModel;
    dsa.SetMergePolicy(1, FarPoint.Web.Spread.Model.MergePolicy.Always);
    FpSpread1.ActiveSheetView.Cells[0, 1, 2, 1].Text = "Test";
    Response.Write(dsa.GetMergePolicy(1)); 
    
    Dim dsa As FarPoint.Web.Spread.Model.ISheetAxisModel
    dsa = FpSpread1.ActiveSheetView.ColumnAxisModel
    dsa.SetMergePolicy(1, FarPoint.Web.Spread.Model.MergePolicy.Always)
    FpSpread1.ActiveSheetView.Cells(0, 1, 2, 1).Text = "Test"
    Response.Write(dsa.GetMergePolicy(1)) 
    See Also