Issues in a converted PDF from a Spreadsheet with multiple rows and cols merged together

Hi Team!

I’d like to report an issue I’m having with Spreadsheet conversion to PDF. When I convert an Excel document to PDF, merged rows only show the first paragraph, or the first line of the original text or some random text from the merged cells.

This is an old known issue and I tried using the live demo to see if the issue was already fixed, but I’m not sure if the issue still remains or if the demo is not using the latest version. Has this issue been patched out?

Thanks!

/edit
I forgot to mention but I’m using Java version 19 of GroupDocs.

@ricardo.oliveira

Could you please share the problematic file? Did you try the latest API version 21.4.

Sure!

spreadsheets.zip (11 KB)

1 Like

@ricardo.oliveira

This issue is reproduce at our end using API version 20.x. We’ve logged it in our internal issue tracking system with ID CONVERSIONJAVA-1351. You’ll be notified in case of any update.

@ricardo.oliveira

Please use setSkipEmptyRowsAndColumns(false) method of SpreadsheetLoadOptions. Let us know if it resolves your issue.