title: PHPExcel, auto resize row height
body: <p>I would like to display the whole text on a generated .xls with PHPExcel 1.8.0. Currently, the cell (actually the whole row) isn't resized even though it didn't set any row height.</p>
  
  <p>here are some screenshots :</p>
  
  <p><a href="https://i.stack.imgur.com/RRQvz.png" rel="noreferrer"><img src="https://i.stack.imgur.com/RRQvz.png" alt="What i got (generated)"></a></p>
  
  <p><a href="https://i.stack.imgur.com/TG7ke.png" rel="noreferrer"><img src="https://i.stack.imgur.com/TG7ke.png" alt="What i would like (obtained on double clicking the &quot;resize row height&quot;)"></a></p>
  
  <p>Here is my code :</p>
  
  <pre><code>$this-&gt;xls-&gt;getActiveSheet()-&gt;getRowDimension($this-&gt;row)-&gt;setRowHeight(-1);
  
  $this-&gt;xls-&gt;getActiveSheet()-&gt;getStyle("A".$this-&gt;row.":F".$this-&gt;row)-&gt;getAlignment()-&gt;setWrapText(true);
  
  $this-&gt;xls-&gt;getActiveSheet()-&gt;getCell("A".$this-&gt;row)-&gt;setValue(APPLICATION_ACADEMY);
  $this-&gt;xls-&gt;getActiveSheet()-&gt;getCell("B".$this-&gt;row)-&gt;setValue(date("d/m/Y"));
  $this-&gt;xls-&gt;getActiveSheet()-&gt;getCell("C".$this-&gt;row)-&gt;setValue($fait['nature'] === null ? $fait['codeNature'] : $fait['nature']);
  $this-&gt;xls-&gt;getActiveSheet()-&gt;getCell("D".$this-&gt;row)-&gt;setValue($fait['etablissement']);
  </code></pre>
  
  <p>I used what i already found on stack (setTextWrap / setRowHeight(-1)) but it has no effect</p>
  
  <p>Anyone got an idea ? Is it even possible ? thanks.</p>