We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback


Thread ID:





102416 Jan 30,2012 03:06 PM UTC Feb 20,2012 01:03 PM UTC ASP.NET Web Forms (Classic) 5
Tags: XlsIO
Asked On January 30, 2012 03:06 PM UTC


When binding a DataTable to a template with markers, merged cells aren't merged anymore...
I'm using insert:copystyles marker, but it doesn't help.
How can I preserve merged cells?

Thank you for your help.

Manoj Kumar G M [Syncfusion]
Replied On February 1, 2012 01:18 PM UTC


Thank you for choosing Syncfusion Products.

You can work around this issue by using “MergedArea” property of the Worksheet Range

The following code snippet illustrates this.

int cells = worksheet1.Range["A1"].MergeArea.Count;

We have attached the sample in the below link. Please make use of this sample and let us know if this helps you.



Please let us know if you require any further clarifications.


Replied On February 1, 2012 02:18 PM UTC


You mean you have to do that manually for each merged cell in the table?
For each merged cell, I'll have to find its row and col by code so that I can do what you said?

I have complex tables, and I thought there was an easier way...

Manikandan M [Syncfusion]
Replied On February 6, 2012 01:09 PM UTC

Hi Gontrand,

Thanks for your patience.

We currently does not provide the support for 'merge style' when applying the template marker. So please find the merged area count and apply the merge for the cells after applying template marker as given in our last update.

We highly regret for the inconvenience.

Please let us know if you need any clarifications.


Balkrishan Dhar
Replied On February 19, 2012 04:45 AM UTC


This i am using to merge the two columns and will be applied to the below rows aswell.

Manikandan M [Syncfusion]
Replied On February 20, 2012 01:03 PM UTC

Hi Balkrishan Dhar,

We highly regret for the inconvenience caused.

We could see that applying copyrange to templatemarker works perfectly for preserving the 'merging style' of the cells in template marker. Thanks for your update.



This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

or the page will be automatically redirected to sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon