This project has moved and is read-only. For the latest updates, please go here.

Merged cells are not read from worksheet


I have a file where the merged cells were not being recognized in two of the worksheets.

It looks like EPPlus makes some assumptions about the order of the elements in order to quickly read through the worksheet XML. In this case, it assumes that a "colBreaks" element will not occur before the "mergeCells" element. However, if a custom view exists in the sheet, the "customSheetViews" element is added before the "mergeCells" element; since a "customSheetView" element can (will?) contain a "colBreaks" element, EPPlus prematurely exits the read loop and assumes that there are no merged cells in the sheet.

This file was last saved from Excel 2013, although the file was originally created in an earlier version of Excel.