Spread Windows Forms 6.0 Product Documentation
MergePolicy Property
See Also  Example Support Options
FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > Row Class : MergePolicy Property

Glossary Item Box

Gets or sets whether to automatically merge adjacent identical cells in this row.


Visual Basic (Declaration) 
Public Property MergePolicy As MergePolicy
Visual Basic (Usage)Copy Code
Dim instance As Row
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


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.


C#Copy Code
FarPoint.Win.Spread.row r;
r = fpSpread1.ActiveSheet.Rows[0];
r.MergePolicy = FarPoint.Win.Spread.Model.MergePolicy.Always;
Visual BasicCopy Code
Dim r As FarPoint.Win.Spread.Row
r = FpSpread1.ActiveSheet.Rows(0)
r.MergePolicy = FarPoint.Win.Spread.Model.MergePolicy.Always


Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

See Also

© 2002-2012 ComponentOne, a division of GrapeCity. All Rights Reserved.