Mergeable Property

Gets or sets a value that indicates whether the Cell can automatically merge.

Syntax

Visual Basic (Declaration)
Visual Basic (Usage)
C#

<DefaultValueAttribute()>
<SRCategoryAttribute("Appearance")>
<SRDescriptionAttribute("Indicates whether the cell can auto merge.")>
Public Property Mergeable As Boolean

Dim instance As Cell
Dim value As Boolean
 
instance.Mergeable = value
 
value = instance.Mergeable

[DefaultValue()]
[SRCategory("Appearance")]
[SRDescription("Indicates whether the cell can auto merge.")]
public bool Mergeable {get; set;}

Property Value

true if the Cell can automatically merge; otherwise, false. The default is false.

Exceptions

Exception	Description
System.InvalidOperationException	Sets property in Runtime.

Remarks

The desired merged cells should be in the "Row" scope.

The cell's top should equal to the row's top, and cell's bottom should be equal to the row's bottom.

If the cell is in the new row, the cell cannot be merged.

If a cell merges with other cells, the MultiRow control uses the first cell's property settings and style to paint the merged cells.

Default merge logic:

1. The desired merged cells' value should not be a null reference (Nothing in Visual Basic) or String.Empty.

2. If two cell's values are the same the cell is merged (Note: For performance reasons do not use FormattedValue, use Value).

If you wish to customize the merge logic, refer to the GcMultiRow.QueryCellMergeState event.

Requirements

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

Reference

Cell Class
Cell Members