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


Glossary Item Box

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

Syntax

Visual Basic (Declaration) 
Public Property MergePolicy As MergePolicy
Visual Basic (Usage)Copy Code
Dim instance As Column
Dim value As MergePolicy
 
instance.MergePolicy = value
 
value = instance.MergePolicy
C# 
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.
C#Copy Code
FarPoint.Win.Spread.Column c;
c = fpSpread1.ActiveSheet.Columns[0];
c.MergePolicy = FarPoint.Win.Spread.Model.MergePolicy.Always;
Visual BasicCopy Code
Dim c As FarPoint.Win.Spread.Column
c = FpSpread1.ActiveSheet.Columns(0)
c.MergePolicy = FarPoint.Win.Spread.Model.MergePolicy.Always

Requirements

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8

See Also

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