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.
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Markers

Thread ID:

Created:

Updated:

Platform:

Replies:

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

Hello,

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

Hi GONTRAND,

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.

[C#]
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.

SampleLink:

http://www.syncfusion.com/downloads/Support/DirectTrac/90287/TemplateMarker-1567013648.zip

Please let us know if you require any further clarifications.

Regards,
Manojkumar.



Johan GONTRAND
Replied On February 1, 2012 02:18 PM UTC

Hi,

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.

Thanks,
Manikandan.M


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


%dvLiqLibSummaryAccts.VALUE_AMT1;vertical;copyrange:R[0]C[0]:R[0]C[2]

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.

Thanks,
Manikandan.M


CONFIRMATION

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.

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

;