This is a migrated thread and some comments may be shown as answers.

Merged cells on single row

11 Answers 559 Views

GridView

This is a migrated thread and some comments may be shown as answers.

11 Answers, 1 is accepted

answered on 08 Feb 2016, 04:04 PM

scrnshot.png

I don't think you understand the question.

Basically, I want to merge cells on a single row of the grid. I don't want headers merged. To give you an example, I might have a grid with 5 rows and 3 columns. I don't want anything merged except 2 cells on row 3. Can I get there? If so, some sample code would be great! The htmlViewDefinition seems like it affects all rows in the grid (including headers), is this correct? If not, please lead the way!

See the attached screen shot for an example of what I am trying to do.

Thanks ... Ed

answered on 09 Feb 2016, 03:09 PM

2016-02-09-1706.png

Hi Randy,

Thank you for writing back.

No, with this method you won't be able to center the text. If you need this for a particular row only, perhaps you can create a custom row element and show the cell, However, this approach would have some limitations as well (for example you will not able to edit the cell).

Here is how you can create the custom row element:

class MyGridRowElement : GridDataRowElement

{

LightVisualElement mycell = new LightVisualElement();

protected override void CreateChildElements()

{

base.CreateChildElements();

mycell.DrawText = true;

mycell.Text = "test";

mycell.DrawFill = true;

mycell.BackColor = Color.White;

mycell.GradientStyle = Telerik.WinControls.GradientStyles.Solid;

mycell.DrawBorder = true;

mycell.BorderBoxStyle = Telerik.WinControls.BorderBoxStyle.FourBorders;

mycell.BorderLeftColor = Color.FromArgb(209, 225, 245);

mycell.BorderTopColor = Color.FromArgb(209, 225, 245);

mycell.BorderBottomColor = Color.FromArgb(209, 225, 245);

mycell.BorderRightWidth = 0;

this.Children.Add(mycell);

}

public override GridCellElement CreateCell(GridViewColumn column)

{

var cell = base.CreateCell(column);

if (column.Index >=2)

{

cell.Visibility = Telerik.WinControls.ElementVisibility.Hidden;

}

return cell;

}

public override bool IsCompatible(GridViewRowInfo data, object context)

{

return false;

}

protected override Type ThemeEffectiveType

{

get

{

return typeof(GridDataRowElement);

}

protected override SizeF ArrangeOverride(SizeF finalSize)

{

var result = base.ArrangeOverride(finalSize);

var X = this.VisualCells[3].ControlBoundingRectangle.X;

var width = this.VisualCells[3].ControlBoundingRectangle.Width + this.VisualCells[4].ControlBoundingRectangle.Width;

mycell.Arrange(new RectangleF(X, 0, width-2, finalSize.Height));

return result;

}

You can use the CreateRow event to change the default row:

private void RadGridView1_CreateRow(object sender, GridViewCreateRowEventArgs e)

{

if (e.RowInfo is GridViewDataRowInfo && e.RowInfo.Index == 2)

{

e.RowElement = new MyGridRowElement();

}

The attached image shows the result on my side.

I hope this helps.

Regards,
Dimitar
Telerik

Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items

answered on 11 Feb 2016, 11:49 AM

Hello Ed,

Thank you for writing back.

I am sorry to hear that you are disappointed and cannot use the grid for your scenario. Semantically, RadGridView's default view (TableViewDefinition) is record based, where cell and rows do not apply, and the only view where we support this is the HtmlViewDefinition, which seems will not work for you as well.

We will strongly consider your feedback and think for a better ways for implementing this functionality. Unfortunately, at this point, there are no other ways for cells merging than the ones I have already shown.
In fact, merging just some records, would be more applicable to a spreadsheet control (like excel), rather than a grid control. If this is what you need, we do have a feature request for such and if you find it useful, feel free to vote for it using the Like button on this page: http://feedback.telerik.com/Project/154/Feedback/Details/136479

If a spreadsheet is what you are looking for, what I can offer for the time being is to look at the offering our WPF suite has for such control: http://docs.telerik.com/devtools/wpf/controls/radspreadsheet/overview. If this is what you are looking for, you can host this component in your WinForms application via element host and take advantage of its capabilities. More information on hosting WPF control in WinForms apps can be found here: http://www.telerik.com/support/code-library/integration-with-wpf

I hope that you find this information useful. Should you have any other questions, do not hesitate to contact us.

Regards,
Dimitar
Telerik

Product Bundles

DevCraft

Web

Mobile

Document Management

Desktop

Reporting

Testing & Mocking

CMS

UI/UX Tools

Debugging

Free Tools

Support and Learning

Productivity and Design Tools

Merged cells on single row

11 Answers, 1 is accepted