Vertical alignment of cell content in PDF export

Aspose.Cells Product Family
1

Dear all,

in recent versions of Aspose.Cells for Java we detected a layout issue.
For cells which are set to centered vertical alignment within our Excel templates the PDF export renders them not centered but top-aligned. I’ve checked versions 8.4.1 and 8.4.2 showing these problems. The output of version 8.3.2.6 is ok. See the attached xlsx template and the PDF output examples. For a good example look for the number “3.364.000,0”.

For demonstration purposes I’ve created the following demo code:

LoadOptions loadOptions = new LoadOptions(FileFormatType.XLSX);
Workbook workbook = null;
workbook = new Workbook(filename, loadOptions);

String outputFilename = filename.replaceAll(".xlsx", “”) + “_out.pdf”;
PdfSaveOptions pdfSaveOptions = new PdfSaveOptions();
workbook.save(outputFilename, pdfSaveOptions);

2

Hi,

Thanks for your posting and using Aspose.Cells.

Please download and try the latest version: Aspose.Cells
for Java v8.4.2.5 it generates correct results.

I have attached the output pdf generated with the latest version for your reference.

3

Dear Shekeel,

thank you very much. The latest version seems to fix our issue.

Best regards,

Benjamin

4

Dear
Benjamin,

Thanks for your feedback and using Aspose.Cells.

It is good to know that your issue is fixed with the latest version. Let us know if you encounter any other issue, we will be glad to look into it and help you further.