Spread Windows Forms 12.0 Product Documentation
MergePolicy Property (Column)
Example 


FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > Column Class : MergePolicy Property
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

Reference

Column Class
Column Members
MergePolicy Property (Row Class)
MergePolicy Enum

User-Task Documentation

Allowing Cells to Merge Automatically