Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread.Model Namespace / BaseSheetAxisModel Class / GetMergePolicy Method
Row or column index
Example


In This Topic
    GetMergePolicy Method (BaseSheetAxisModel)
    In This Topic
    Gets the cell merge policy for the specified row or column.
    Syntax
    'Declaration
     
    Public Overridable Function GetMergePolicy( _
       ByVal index As Integer _
    ) As MergePolicy
    'Usage
     
    Dim instance As BaseSheetAxisModel
    Dim index As Integer
    Dim value As MergePolicy
     
    value = instance.GetMergePolicy(index)
    public virtual MergePolicy GetMergePolicy( 
       int index
    )

    Parameters

    index
    Row or column index

    Return Value

    MergePolicy setting that determines how the automatic merging is done
    Example
    This example gets the policy for whether to automatically merge adjacent identical cells in the specified column.
    FarPoint.Win.Spread.Model.BaseSheetAxisModel baseModel;
    baseModel = (FarPoint.Win.Spread.Model.BaseSheetAxisModel)fpSpread1.ActiveSheet.Models.ColumnAxis;
    baseModel.SetMergePolicy(1, FarPoint.Win.Spread.Model.MergePolicy.Always);
    listBox1.Items.Add(baseModel.GetMergePolicy(1).ToString());
    Dim baseModel As FarPoint.Win.Spread.Model.BaseSheetAxisModel
    baseModel = fpSpread1.ActiveSheet.Models.ColumnAxis
    baseModel.SetMergePolicy(1, FarPoint.Win.Spread.Model.MergePolicy.Always)
    ListBox1.Items.Add(baseModel.GetMergePolicy(1).ToString)
    See Also