Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.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
    Example
    This example returns the merge policy for the specified column.
    FarPoint.Win.Spread.Model.DefaultSheetAxisModel dsam = new FarPoint.Win.Spread.Model.DefaultSheetAxisModel(3, FarPoint.Win.Spread.Model.SheetAxisOrientation.Horizontal);
    dsam = (FarPoint.Win.Spread.Model.DefaultSheetAxisModel)fpSpread1.ActiveSheet.Models.ColumnAxis;
    dsam.SetMergePolicy(0, FarPoint.Win.Spread.Model.MergePolicy.Always);
    FarPoint.Win.Spread.Model.MergePolicy p;
    p = dsam.GetMergePolicy(0);
    MessageBox.Show("The merge policy is " + p.ToString());
    
    fpSpread1.ActiveSheet.SetText(0, 0, "Test");
    fpSpread1.ActiveSheet.SetText(1, 0, "Test");
    fpSpread1.ActiveSheet.SetText(2, 0, "Test");
    
    
    Dim dsam As New FarPoint.Win.Spread.Model.DefaultSheetAxisModel(3, FarPoint.Win.Spread.Model.SheetAxisOrientation.Horizontal)
    dsam = fpSpread1.ActiveSheet.Models.ColumnAxis
    dsam.SetMergePolicy(0, FarPoint.Win.Spread.Model.MergePolicy.Always)
    Dim p As FarPoint.Win.Spread.Model.MergePolicy
    p = dsam.GetMergePolicy(0)
    MessageBox.Show("The merge policy is " & p.ToString())
    
    fpSpread1.ActiveSheet.SetText(0, 0, "Test")
    fpSpread1.ActiveSheet.SetText(1, 0, "Test")
    fpSpread1.ActiveSheet.SetText(2, 0, "Test")
    See Also