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

Aspose.Cells Product Family
1

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

2

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).
3

Hi ,

Thank you very much for the quick reply.

It worked for me.

Regards,

Hardik Shah

4

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.