Jan 11, 2013 at 6:30 PM
Edited Jan 11, 2013 at 6:33 PM
I am building a spreadsheet with a column that will hold a lot of text. I have set that column to wrap like this
$arrStyleContentsFormat = array(
'font' => array(
'bold' => false,
'size' => 9
'alignment' => array(
'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_LEFT,
'wrap' => true,
Then as I loop through and build each row I am specifying a -1 in the rowheight like this
However when the spreadsheet prints the rows are small and I cannot see all the text.
I am also tried using AutoSize, but that only extends the width, not the height.
I am using PHPExcel 1.7.7 on Windows 7 x64.