Issue in Row Height Expand

Aspose.Cells Product Family
1

Dear Team,


I am working on a requirement where we need to display a huge text dynamically received from database into one of the column. But the problem we are facing is like the row height is not expanded based on the cell content.

I am hereby attaching the test documents. Kindly help me in resolving the issue.

Thanks and Regards
Pradeep
2

Hi Pradeep,


Thank you for contacting Aspose support.

I suspect that you are not calling the Worksheet.autoFitRows before rendering the spreadsheet to PDF format. Please use the following statement (or amend it according to Worksheet name) after filling the data into the Worksheet or just before converting it to PDF format.

In case the problem persists, we require a sample standalone application replicating the said issue. Please make sure that the sample application should not require the database connectivity when we test the scenario on our side.

Java

workbook.getWorksheets().get(“Sheet1”).autoFitRows();