setRowHeight from getDefaultRowDimension not working with data has wrapText

[ckan719]

I use $sheetEdit->getDefaultRowDimension()->setRowHeight(15); but it is not working when data has wrapText, so i use

for ($row = 1; $row <= $highestRow; $row++) {
    $sheetEdit->getRowDimension($row)->setRowHeight(15);
}

as an alternative. But it is very memory consuming if the number of rows is large. Is there any solution to fix this problem?

[chethan7032]

we can just Disable automatic row height adjustment with wrapText as below

$sheetEdit->getStyle($sheetEdit->calculateWorksheetDimension())
->getAlignment()
->setWrapText(false);
$sheetEdit->getDefaultRowDimension()->setRowHeight(15);

[ckan719]

we can just Disable automatic row height adjustment with wrapText as below

$sheetEdit->getStyle($sheetEdit->calculateWorksheetDimension()) ->getAlignment() ->setWrapText(false); $sheetEdit->getDefaultRowDimension()->setRowHeight(15);

Thanks. But my data must be keep wrapText. So can't use option setWrapText(false)

[oleibman]

This seems more difficult than it ought to be. I truly do not understand why Excel works the way it does. Here is an excerpt from one of my testing programs:

    /**
     * Very odd. Code below makes all row heights 20, including row with
     * wrapped cell. To get that row to arrive at its "natural" hieght,
     * you can add customFormat="1" ht="-1" to the row tag.
     * However, this also causes all populated rows to revert to the
     * default Excel height, not the default row height for the sheet.
     * Those rows can take the sheet default row height by adding
     * customHeight="1" to the xml.
     */

The fact that setting customFormat on one row can affect all other rows just seems bizarre to me. So, while I have an idea of what needs to be done, coming up with an intelligent way to implement it seems tricky. It is on my to-do list.