title: Unmerge and clear cells in epplus 4.1
body: <p>I had no luck deleting rows in excel so now I try to clear their content and still get the error:
  "Can't delete/overwrite merged cells. A range is partly merged with the another merged range. A57788:J57788".</p>
  
  <p>Columns 1-10 are really merged, but how do I unmerge them?</p>
  
  <p>Here's my code:</p>
  
  <pre><code>cntr = 0;
  while (ws.Cells[RowNum + cntr, 1].Value == null || !ws.Cells[RowNum + cntr, 1].Value.ToString().StartsWith("Report generation date"))
  {
      ws.Cells[RowNum + cntr, 1, RowNum + cntr, 18].Value = "";
      ws.Cells[RowNum + cntr, 1, RowNum + cntr, 10].Merge = false;
      for (int i = 1; i &lt; 17; i++)
      {
          ws.Cells[RowNum + cntr, i].Style.Border.BorderAround(OfficeOpenXml.Style.ExcelBorderStyle.None);
          ws.Cells[RowNum + cntr, i].Clear();
      }
      cntr++;
  }
  //ws.DeleteRow(RowNum, cntr);
  </code></pre>