We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Excel to PDF export - Text is getting cut for merged cells

Hi

during excel generation, I have written following code in one of the section.

worksheet.getCells().merge(0, 0, 1, 3);

worksheet.getSheet().getCells().get(0, 0).putValue("BOCI FIF");

Excel is getting generated properly. But when I am converting this excel to pdf using aspose, lower half of the text is not visible as shown in the attached file Test.png.

Please suggest.

Thanks

Hardik Shah

Hi Hardik,


Thank you for contacting Aspose support.

Please call the Worksheet.autoFitRows method before saving the spreadsheet in PDF format. Please check the below provided code snippet for your reference.

Java

//Create an object for AutoFitterOptions
AutoFitterOptions options = new AutoFitterOptions();
//Set auto-fit for merged cells
options.setAutoFitMergedCells( true);
//Autofit rows in the sheet(including the merged cells)
worksheet.autoFitRows(options);

In case the problem persists, please provide us your complete code as well as the template file (if any).

Hi ,

Thank you very much for the quick reply.

It worked for me.

Regards,

Hardik Shah

Hi Hardik,


Good to know that you are up and running again. Please feel free to write back in case you need our further assistance.