Hi,
We are just reviewing 2011.1 release and it seems to have lot of new features including Cell Merge in XamGrid. We have noticed that Cell Merge is handled with GroupBySettings GroupByOperation="MergeCells" and it allows the cells to merge the cells in adjacent rows. We are looking forward if there is any way to merge cells in columns too?
I have gone through samples and some forum items. from there it seems not to be available. please confirm us about this.
Thanks
Imran Javed Zia said: Can you let me know if we can merge cell in a single column dynamically/runtime without using Group by settings?
Can you let me know if we can merge cell in a single column dynamically/runtime without using Group by settings?
The CellMerging feature works only when GroupByOperation property of the GroupBySettings object is set to MergeCells. You don't need to have the GroupByArea enabled to group cells. Then you can set the IsGroupBy property of a Column to true or add the column to the GroupByColumns collection (XamGrid.Columns.GroupByColumns). If you want to implement custom grouping you can check this help article.
For more information about Cell Merging and the behaviour of the XamGrid when cells are merged check this article.
Regards
Nikolay,
We REALLY need the ability for text written in one cell to run into the adjacent column cell automatically if it is empty (like Excel does.) While we have successfully combined the Infragistics Excel library with your Silverlight grid for an almost spreadsheet-like tool, until Infragistics adds this text over-run ability none of your clients will be able to create a truly on-line spreadsheet app (with titles than span multiple columns, etc). So this should be of the highest priority for your development team...
Eric Linder
President, SavaNet LLC
Hi Zikolay Zhekov,
The new Cell Merging feature of the XamGrid provides a new UI pattern for GroupBy where Group values are shown as merged cells in a special column, rather than collapsed row headers.
The Cell Merging works on column lavel. The XamGrid does not offer a way to merge cells from different columns (like ColumnSpan).