Cells.merge functionality bug

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.




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.