There is an issue with Excel report cells that has text that is longer than the cell. It will get truncated when the Excel is converted to PDF. Even if we set the cell to wrap, it won’t expand the cell and row to accommodate the extra lines of text in that cell. If we set the row height to -1 in the yarg code, it will auto-expand the row height to fit the extra lines ONLY if you open up the document in Excel or Open Office. But if you ask for a PDF output, it will not expand the row height and the extra lines of text will spill into the next row and overlap with the next row text. Why ?
So, is there a way to open it in OpenOffice and have it adjust the row heights first before exporting it out in PDF format ? If the XLSX file is output and saved first and then opened, the row heights are correct and when exported to PDF, the PDF layout is also correct.