There is an unsaved comment in progress. You will lose your changes if you continue. Are you sure you want to reopen the work item?
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.