1
Vote

Merge thows exception after DeleteRow, with fix

description

The attached sample demonstrates the problem with Mergin cells after deleting rows.

The problem is in ExcelWorksheet.cs function: internal void Clear(ExcelAddressBase Destination)
My fix recomendet fix is to change the if statement on row: 334 to the following:
if (Destination.Collide(adr) != ExcelAddressBase.eAddressCollition.No)

instead of the existing:
if (!(Destination.Collide(adr) == ExcelAddressBase.eAddressCollition.Inside || Destination.Collide(adr) == ExcelAddressBase.eAddressCollition.Equal))

file attachments

comments