title: PHPExcel setAutoSize for merged cells
body: <h3>Code without merge</h3>
  <pre><code>$objPHPExcel = new PHPExcel();
  $sheet = $objPHPExcel-&gt;getActiveSheet();
  
  $sheet-&gt;setCellValueByColumnAndRow(0, 1, 
          &quot;test test test test test test test test&quot;);
  $sheet-&gt;getColumnDimension('A')-&gt;setAutoSize(true);
  
  $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
  $objWriter-&gt;save(&quot;test.xlsx&quot;);
  </code></pre>
  <p><img src="https://i.stack.imgur.com/6HQ73.png" alt="enter image description here" /></p>
  <h3>Code with merge</h3>
  <pre><code>$objPHPExcel = new PHPExcel();
  $sheet = $objPHPExcel-&gt;getActiveSheet();
  
  $sheet-&gt;setCellValueByColumnAndRow(0, 1, 
          &quot;test test test test test test test test&quot;);
  //this breaks the width calculation
  $sheet-&gt;mergeCells('A1:B1');
  $sheet-&gt;getColumnDimension('A')-&gt;setAutoSize(true);
  
  $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
  $objWriter-&gt;save(&quot;test.xlsx&quot;);
  </code></pre>
  <p><img src="https://i.stack.imgur.com/uH0O0.png" alt="enter image description here" /></p>
  <p>As far as I understand, there is no standard way to set auto size for merged cells. Is there any workaround for this?</p>