Multiple cell merge

[gdo]

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]

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]

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]

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