»Spread for ASP.NET  » Product Tour  » Cell Merging

jump to: - select feature - Welcome to the Spread for... AJAX Support Cell Merging Cell Types AJAX Extender Cell Types Conditional Formatting Data Binding Excel Compatibility Filtering Formulas Frozen Rows & Columns Grouping Hierarchy Import / Export LayoutMode - Row Template Load on Demand Move Columns Operation Modes Order Entry Sample Paging Preview Row Summary Print/Print To PDF Row Edit Templates Scroll Tips Searching Sheets Skins Sorting Spread Designer Summary Aggregation Unbound Mode Worksheet Rate this Tour

Cell Merging

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 TV Schedules (Row Merge)

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