adjusting row height in phpexcel
<p>I've just been trying unsuccessfully to get phpexcel (PHPExcel_Writer_Excel2007) to automatically adjust row height based on content, when that content contains newline characters. At the moment, only the final line is visible. I've tried setting the row height to -1 for the row in question and the whole column i.e.</p>

<pre><code>$objPHPExcel-&gt;getActiveSheet()-&gt;getRowDimension(65)-&gt;setRowHeight(-1);
</code></pre>

<p>and</p>

<pre><code>$objPHPExcel-&gt;getActiveSheet()-&gt;getDefaultRowDimension()-&gt;setRowHeight(-1);
</code></pre>

<p>but it makes no difference. Help appreciated. Cheers</p>