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.