PHPExcel 设置 setRowHeight(-1) 和 setWrapText(true) 不会自动调整行的高度

Question

已尝试以下方法，但没有帮助，接下来我应该尝试什么？我错过了什么？

$objPHPExcel->getActiveSheet()->setCellValue('A10', 'Value1, Value2, Value3, Value4, Value5');
$objPHPExcel->getActiveSheet()->getRowDimension(10)->setRowHeight(-1);
$objPHPExcel->getActiveSheet()->getStyle('A10')->getAlignment()->setWrapText(true);

然后

$objPHPExcel->getDefaultStyle()->getAlignment()->setWrapText(true);
foreach($objPHPExcel->getActiveSheet()->getRowDimensions() as $rd) { 
    $rd->setRowHeight(-1); 
}

还

$objPHPExcel->getActiveSheet(0)->getStyle('A1:D10')->getAlignment()->setWrapText(true);
$objPHPExcel->getActiveSheet()->getRowDimension(1)->setRowHeight(-1);
$objPHPExcel->getActiveSheet()->getRowDimension(2)->setRowHeight(-1);
$objPHPExcel->getActiveSheet()->getRowDimension(3)->setRowHeight(-1);
$objPHPExcel->getActiveSheet()->getRowDimension(4)->setRowHeight(-1);
$objPHPExcel->getActiveSheet()->getRowDimension(5)->setRowHeight(-1);
$objPHPExcel->getActiveSheet()->getRowDimension(6)->setRowHeight(-1);
$objPHPExcel->getActiveSheet()->getRowDimension(7)->setRowHeight(-1);

Answer 1

似乎这是 LibreOffice 的已知错误:

https://bugs.documentfoundation.org/show_bug.cgi?id=62268

https://github.com/PHPOffice/PHPExcel/issues/588