FarPoint Technologies, Inc.

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.

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	Tofu	9	18.6
5	10249	Manjimup Dried Apples	40	42.4
6	10250	Jack's New England Clam Chowder	10	7.7
7		Manjimup Dried Apples	35	42.4
8		Louisiana Fiery Hot Pepper Sauce	15	16.8
9	10251	Gustaf's Knäckebröd	6	16.8
10		Ravioli Angelo	15	15.6
11		Louisiana Fiery Hot Pepper Sauce	20	16.8
12	10252	Sir Rodney's Marmalade	40	64.8
13		Geitost	25	2
14		Camembert Pierrot	40	27.2
15	10253	Gorgonzola Telino	20	10
16		Chartreuse verte	42	14.4
17		Maxilaku	40	16
18	10254	Guaraná Fantástica	15	3.6
19		Pâté chinois	21	19.2
20		Longlife Tofu	21	8

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