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.
Please try the attached latest fix v220.127.116.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.