PHPExcel
PHPExcel copied to clipboard
Image height squashed to 75% (PHPExcel_Worksheet_Drawing)
Hi there, thank you for this great set of tools!
I'm using PHPExcel_Worksheet_Drawing to place images inside the worksheet, everything is working fine except that images' height is squashed to 75%. I'm only using 'setRowHeight' to set the row height and nothing else that could impact the image size.
Once the produced excel file is opened in MS Excel and opening 'Format Picture' for each image the info under 'Size' -> 'Scale' is set to 'Height: 75%' and 'Width: 100%' - changing Height to 100% corrects the image.
Any help as to why would be much appreciated.
I hava same problem, could you tell me how me solve it?
i solve it, with this:
$this->spreadsheet->getActiveSheet()->getRowDimension(1)->setRowHeight($drawing->getHeight() - ($drawing->getHeight() * .25));
$drawing->setWorksheet($this->spreadsheet->getActiveSheet());