Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread Namespace / Column Class / MergePolicy Property
Example


In This Topic
    MergePolicy Property (Column)
    In This Topic
    Gets or sets whether to automatically merge adjacent identical cells in this column.
    Syntax
    'Declaration
     
    Public Property MergePolicy As MergePolicy
    'Usage
     
    Dim instance As Column
    Dim value As MergePolicy
     
    instance.MergePolicy = value
     
    value = instance.MergePolicy
    public MergePolicy MergePolicy {get; set;}

    Property Value

    MergePolicy setting of how to handle automatic merging
    Remarks

    To allow adjacent identical cells to be merged automatically, set this property.

    For more information on automatic merging of cells, refer to Allowing Cells to Merge Automatically .

    If you are using a specific cell type, be careful of restrictions for that cell type. For example, in order for automatic merging to work with CheckBox cells, the Value needs to be set to true or false instead of 1 or 0.

    Example
    This example sets the MergePolicy for the first column.
    FarPoint.Win.Spread.Column c;
    c = fpSpread1.ActiveSheet.Columns[0];
    c.MergePolicy = FarPoint.Win.Spread.Model.MergePolicy.Always;
    Dim c As FarPoint.Win.Spread.Column
    c = fpSpread1.ActiveSheet.Columns(0)
    c.MergePolicy = FarPoint.Win.Spread.Model.MergePolicy.Always
    See Also