Hi all,
I seem to have found a rather frustrating bug when using document converter.
Steps to replicate:
-
Create and XLSX, add some text into some text into some cells, so they text is a little larger than the cell.
-
Choose “text wrap” in Excel or OnlyOffice. - This will wrap the text on to the next line.
-
Copy this row a few times, so it’s more than one “printable page”
-
Convert the XLSX to PDF
You’ll notice the converter converts these rows, but it doesn’t respect the height of those cells when placing them on the PDF page. That means, if you have lots of cells like this, it can easy overflow beyond the length of the page and become invisible.
I tried to get around this by converting to CSV first (this will remove text wrapping of course), then convert to PDF, however the XLSX to CSV converstion struggles with some of the formula in the XLSX when “flattening” to CSV.
Hopefully someone can take a look into this.
If you need any example documents, I’m happy to provide.
For what it’s worth, you can also reproduce this in the standard web editor, by choosing to download such an XLSX document as PDF, but I’m guessing that uses the same conversion API.