title: EPPlus vertical alignment of text to center of merged cells is not working
body: <p>I am trying to vertical align the text to the center but its not working. Text is coming at the bottom of merged cell. Here is the minimal code that is not working.</p>
  
  <pre><code>// get handle to the existing worksheet
  ExcelWorksheet worksheet = xlPackage.Workbook.Worksheets.Add("mysheet");
  
  //[row,col]
  worksheet.Cells[1, 1].Value = "a1";
  worksheet.Cells[2, 1].Value = "a1";
  worksheet.Cells[3, 1].Value = "a1";
  worksheet.Cells[4, 1].Value = "a1";
  worksheet.Cells[5, 1].Value = "a1";
  worksheet.Cells[6, 1].Value = "a1";
  
  //comment out below six lines to make it work
  worksheet.Cells[1, 2].Value = "11";
  worksheet.Cells[2, 2].Value = "12";
  worksheet.Cells[3, 2].Value = "13";
  worksheet.Cells[4, 2].Value = "14";
  worksheet.Cells[5, 2].Value = "15";
  worksheet.Cells[6, 2].Value = "16";
  //comment out above six lines to make it work
  
  worksheet.Cells["A1:A6"].Merge = true;
  worksheet.Cells["A1:A6"].Style.VerticalAlignment = ExcelVerticalAlignment.Center;
  
  xlPackage.Save();
  </code></pre>
  
  <p>Please help.</p>
  
  <p>Adding these lines at the end makes it work:</p>
  
  <p>worksheet.Column(1).Style.VerticalAlignment = ExcelVerticalAlignment.Center;
  worksheet.Column(2).Style.VerticalAlignment = ExcelVerticalAlignment.Center;</p>
  
  <p>That means I have to center align all the columns in order to center align the first column.</p>