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

110248Queso Cabrales1214
2Singaporean Hokkien Fried Mee109.8
3Mozzarella di Giovanni534.8
410249Manjimup Dried Apples4042.4
610250Manjimup Dried Apples3542.4
7Jack's New England Clam Chowder107.7
8Louisiana Fiery Hot Pepper Sauce1516.8
910251Louisiana Fiery Hot Pepper Sauce2016.8
10Gustaf's Knäckebröd616.8
11Ravioli Angelo1515.6
13Sir Rodney's Marmalade4064.8
14Camembert Pierrot4027.2
16Chartreuse verte4214.4
17Gorgonzola Telino2010
1810254Pâté chinois2119.2
19Longlife Tofu218
20Guaraná Fantástica153.6

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

ABCExtreme Makeoverlife as we know itPrimeTime
CBSSurvivorCSI:Without a Trace
FOXThe O.CNorth Shore10PM NewsExtra
NBCJoeyWill & GraceThe ApprenticeER

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.