Text with very small font doesn't fit in cell when printing

Topics: Developer Forum
Dec 2, 2013 at 9:33 AM
Hi everybody!

I've got a problem with PHPExcel : I have to generate a xlsx file on the fly that displays a table with a lot of data.

This document has to be printed in a minimum of pages. So I set the font to 6 pts and played with document margins. So, on screen, the sheet is displayed in the right way but not when I print it. Sometimes, the text doesn't fit anymore in some cells and it is cut off. I have to increase the row height manually.

I tried some tricks with things like
$objPHPExcel->getActiveSheet()->getRowDimension($rowNumber)->setRowHeight(-1);
...or to change the font but the problem still here.

Can someone can give me a hand or just explain to me what I am doing wrong? It would be much appreciated! Thank you very much!