Cell Merging - Overview

Overview

Sample

Click on the checkbox below to toggle Spread's merging feature.

Merge Order ID (Column Merge)

	OrderID	ProductName	Quantity	UnitPrice
1	10248	Queso Cabrales	12	14
2		Singaporean Hokkien Fried Mee	10	9.8
3		Mozzarella di Giovanni	5	34.8
4	10249	Manjimup Dried Apples	40	42.4
5	10249	Tofu	9	18.6
6	10250	Manjimup Dried Apples	35	42.4
7		Jack's New England Clam Chowder	10	7.7
8		Louisiana Fiery Hot Pepper Sauce	15	16.8
9	10251	Louisiana Fiery Hot Pepper Sauce	20	16.8
10		Gustaf's Knäckebröd	6	16.8
11		Ravioli Angelo	15	15.6
12	10252	Geitost	25	2
13		Sir Rodney's Marmalade	40	64.8
14		Camembert Pierrot	40	27.2
15	10253	Maxilaku	40	16
16		Chartreuse verte	42	14.4
17		Gorgonzola Telino	20	10
18	10254	Pâté chinois	21	19.2
19		Longlife Tofu	21	8
20		Guaraná Fantástica	15	3.6

Code for merging Column 0:
FpSpread1.Sheets[0].SetColumnMerge(0, FarPoint.Web.Spread.Model.MergePolicy.Always)

Merge TV Schedules (Row Merge)

	8:00	8:30	9:00	9:30	10:00	10:30
ABC	Extreme Makeover		life as we know it		PrimeTime
CBS	Survivor		CSI:		Without a Trace
FOX	The O.C		North Shore		10PM News	Extra
NBC	Joey	Will & Grace	The Apprentice		ER

Code for merging all Rows:
FpSpread1.Sheets[0].SetRowMerge(-1, FarPoint.Web.Spread.Model.MergePolicy.Always)

You can have Spread automatically merge cells between columns or between rows if the cells have the same value based on the policy that you set. The control can automatically combine cells that have the same contents. You might want to do this for easier viewing of the data, for example, when bound to a database.

Unlike spanning cells, merging is an automatic feature. You tell the control which columns and rows allow cells to be combined automatically, and any cells within that set that have the same contents are combined for you.

Documentation