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 : Nov 16th 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Multiple cell merge

Thread ID:

Created:

Updated:

Platform:

Replies:

61202 May 21,2007 03:55 PM UTC May 23,2007 12:20 PM UTC ASP.NET Web Forms (Classic) 3
loading
Tags: XlsIO
gdo
Asked On May 21, 2007 03:55 PM UTC

Hi again,

First problem : I want to merge 4 cells every 6 cells 3 times in the same row, but it seems to work only for the last range the merge is executed on... I've tried to put my ranges in an IRanges and execute Merge() on it but it doesn't work better, only the last merge works.

Second problem is that I have an %Response.label in a merged cell which is populated with a DataTable. I've put ;insert:copystyles on the line, but the merge isn't duplicated every row... how to do it ?

Thanks,
Greg

Melba Winshia [Syncfusion]
Replied On May 22, 2007 09:56 AM UTC

Hi Greg,

Issue 1: (Merge)
---------

I was not able to reproduce the issue. I created a sample to merge 4 cells 3 times in the same row and merging works fine for all ranges. Here is the test sample that I used to test this issue:

http://websamples.syncfusion.com/samples/XlsIO.Web/4.4.0.51/F61202/main.htm

Could you please take a look at the sample above and kindly let me know if you still find any problem, if not could you please modify this sample so that I can reproduce the issue? This would help me in investigating this issue further.

Issue 2: (Merged cell with DataTable)
--------

insert:copystyles is used only to copy style from the above row or left column. But it is not possible to duplicate the merge every row. And also, currently it is not possible to duplicate the merge every row by using template markers. Sorry for the inconvenience caused.

Kindly let me know if you have any other questions.

Thanks,
Melba

gdo
Replied On May 22, 2007 10:20 AM UTC

Hi,

Thanks for the sample.

Your example works but what I'm doing doesn't work.

Here's the code :

--------------------------------
IRanges ranges = sheet.CreateRangesCollection();

==loop==
ranges.Add(sheet.Range[supRowIndex, supColIndex, supRowIndex, supColIndex + supColWidth]);
ranges.Add(sheet.Range[dateRowIndex, dateColIndex, dateRowIndex, dateColIndex + dateColWidth]);
==endloop=

marker.ApplyMarkers();
ranges.Merge();
--------------------------------

With this code my cells doesn't merge.

Greg

Melba Winshia [Syncfusion]
Replied On May 23, 2007 12:20 PM UTC

Hi Greg,

Thanks for the update.

I created a sample with your code snippet. But I was not able to reproduce the issue and the merging works fine. Here is the test sample that I used to test this issue:

http://websamples.syncfusion.com/samples/XlsIO.Web/4.4.0.51/F61202_12/main.htm

Could you please take a look at the sample above and kindly let me know if you still find any problem, if not could you please modify this sample so that I can reproduce the issue? This would help me in investigating this issue further

Thanks,
Melba


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

;