title: Set auto height in PHPExcel not working
body: <p>I am generating Excel using PHPExcel.</p>
  
  <p>All Code Works Fine.But Auto height code is not Working.</p>
  
  <p>I have tried following code.</p>
  
  <p>Apply row height on specific row</p>
  
  <pre><code>$objPHPExcel-&gt;getActiveSheet()-&gt;getRowDimension('7')-&gt;setRowHeight(-1); 
  </code></pre>
  
  <p>Apply row height on for all row</p>
  
  <pre><code>$objPHPExcel-&gt;getActiveSheet()-&gt;getDefaultRowDimension(1)-&gt;setRowHeight(-1);
  </code></pre>
  
  <p>I have also tried word wrap property with it.</p>
  
  <pre><code>$objPHPExcel-&gt;getActiveSheet()
      -&gt;getStyle('B7')
      -&gt;getAlignment()
      -&gt;setWrapText(true);
  </code></pre>
  
  <p>But it give me result as below: </p>
  
  <p><a href="https://i.stack.imgur.com/SQc5e.png" rel="noreferrer"><img src="https://i.stack.imgur.com/SQc5e.png" alt="enter image description here"></a></p>
  
  <blockquote>
    <p>Note : Working in MS office,Not Working in Apache open Office and
    LibreOffice</p>
  </blockquote>