Cell Merging During Row and Column Insertions in .NET Excel Library

13 Aug 20261 minute to read

In Microsoft Excel, when inserting rows or columns using formatting options such as “Format as Before” or “Format as After” only the formatting (such as font, color, and borders) is applied from the adjacent rows or columns. However, merged cell structures are not duplicated. Even if the neighboring row or column contains merged cells, the newly inserted row or column will contain unmerged, individual cells.

The Syncfusion Excel library follows the same behavior. So, when inserting a row with the “Format as Before” or “Format as After” option, cells in the inserted row or column are not merged.