Cells.merge functionality bug

[r_a_ven]

So my requirement is to merger cells in adjoining rows. But I run into wierd issue… In the file "Original.jpg"

I have marked in yellow, the cells that I want merged.

So I wrote the following code:

wsheet.Cells.Merge(8, 1, 1, 3)

wsheet.Cells.Merge(9, 1, 1, 3)

The intended effect is in Required.jpg

But the effect is totally un-anticipated… Look at actual.jpg.

[Amjad_Sahi]

Hi,

Please try the attached latest fix v4.8.0.11, I have implemented your scenario a bit with it and could not find the issue.

If you still find the issue, kindly post your template file here, we will check it soon.

Thank you.