I’m creating an excel document using xlsxwriter thorugh python. However, I have a requirement to output the same file in PDF format. I’ve tried to use the LibreOffice command line option for converting *.xlsx file to PDF but I always end up with an overlapping text. At first, I though I had my code wrong but when I try to open the same file in MS Excel, the row heigth gets adjusted to fit the text. Then I tried installing OpenOffice and open the same file, it too had the row heigt adjusted properly to fit the text.
It was also mentioned in the xlsxwriter github account but gets dismissed saying that
“…there is no guarantee that LibreOffice or any other spreadsheet application will do this and there is nothing in the file format that XlsxWriter can control to automatically adjust the row height…”
So if OpenOffice can get it right how come LibreOffice don’t? It’s critical for me because I use LibreOffice to convert the Excel format into PDF while preserving most of layout formatting.
MS Excel 2013