Merged rows not updated correctly with RemoveRow

[neclepsio]

Description

Merged rows not updated correctly with RemoveRow, as per the following reproducer.

Steps to reproduce the issue:

package main

import (
	"github.com/xuri/excelize/v2"
)

func main() {
	f := excelize.NewFile()
	defer f.Close()

	// create three rows, two of which have merged cells
	f.MergeCell("Sheet1", "A1", "D1")
	f.SetCellStr("Sheet1", "A1", "Merged cells 1")

	f.MergeCell("Sheet1", "A2", "D2")
	f.SetCellStr("Sheet1", "A2", "Merged cells 2")

	f.SetCellStr("Sheet1", "A3", "Non")
	f.SetCellStr("Sheet1", "B3", "merged")
	f.SetCellStr("Sheet1", "C3", "cells")

	// duplicate the three rows
	f.DuplicateRowTo("Sheet1", 1, 4)
	f.DuplicateRowTo("Sheet1", 2, 5)
	f.DuplicateRowTo("Sheet1", 3, 6)

	// rows 1, 2, 4, 5 are merged now; 3 and 6 are not
	f.RemoveRow("Sheet1", 4)

	// BUG
	// should be: rows 1, 2, 4 merged; 3 and 5 not merged
	// is: rows 1, 2, 5 merged; 3 and 4 not merged

	f.SaveAs("Book1.xlsx")
}

Describe the results you received:

Rows 1, 2, 5 merged; 3 and 4 not merged.

Describe the results you expected:

Rows 1, 2, 4 merged; 3 and 5 not merged.

Output of go version:

go version go1.21.4 windows/amd64

Excelize version or commit ID:

v2.8.1-0.20231209040829-7b3dd03947bd

[xuri]

Thanks for your issue. This issue has been fixed, please upgrade to the master branch code, and this patch will be released in the next version.