SetColumnMerge Method

Sets whether or how cells in a column on this sheet that have the same content are joined in a single cell across multiple rows.

Syntax

Visual Basic
C#

'Declaration
 
Public Sub SetColumnMerge( _
   ByVal column As Integer, _
   ByVal value As MergePolicy _
)

'Usage
 
Dim instance As SheetView
Dim column As Integer
Dim value As MergePolicy
 
instance.SetColumnMerge(column, value)

public void SetColumnMerge( 
   int column,
   MergePolicy value
)

Parameters

column: Column index
value: MergePolicy enumeration setting

Remarks

The MergePolicy setting specifies if and how cells in this column are automatically merged.

Example

This example sets all cells in a column that contain the same data to automatically merge.

FpSpread1.ActiveSheetView.Cells[0, 2, 2, 2].Text = "Test";
FpSpread1.ActiveSheetView.SetColumnMerge(2, FarPoint.Web.Spread.Model.MergePolicy.Always);

Visual Basic

FpSpread1.ActiveSheetView.Cells(0, 2, 2, 2).Text = "Test"
FpSpread1.ActiveSheetView.SetColumnMerge(2, FarPoint.Web.Spread.Model.MergePolicy.Always)

Requirements

Target Platforms: Windows 7, Windows 8, Windows Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6

Reference

SheetView Class
SheetView Members
GetColumnMerge Method
SetRowMerge Method

User-Task Documentation

Merging Cells Automatically