Cells missing during pdf conversion when multiple print-areas defined in a single sheet

Aspose.Cells Product Family
1

Hi,


While converting attached excel file to pdf, we can see that not everything from the defined print-area cells is going into PDF output. Observe Pg 7 and 8, you will see differences between Aspose and Office outputs.

Looks like when multiple print areas are defined within a single sheet, Aspose messes it up. Please check.

String fileName = “Book1.xlsx”;
Workbook workbook = new Workbook(fileName);
workbook.save(fileName + “.pdf”, FileFormatType.PDF);

Thanks,
Rajiv
2

Hi Rajiv,

Thank you for sharing the samples.

We have evaluated the presented scenario while using the latest version of Aspose.Cells for Java 8.9.2.2, and we are able to notice the said problem, that is; Aspose.Cells for Java API is not honoring all the print areas set for the worksheet “Multiple print-areas”. In order to further investigate the matter and to provide the fix, a ticket with Id CELLSJAVA-41967 has been logged in our database. Please spare us little time for proper analysis. In the meanwhile, we will keep you posted with updates in this regard.

3

Hi again,

This is to update you that we have resolved the problem logged earlier as CELLSJAVA-41967. We will shortly share the fix here for your testing.

4

Thanks Babar for quick response & resolution !


Regards,
Rajiv
5

Hi,


Please try our latest version/fix: Aspose.Cells for JAVA v8.9.2.3 (attached).

Your issue should be fixed in it.

Let us know your feedback.

Thank you.
6

Yup, it’s working as expected with the the latest build.


Thanks,
Rajiv
7

Hi,


Thanks for your feedback.

Good to know that your issue is sorted out by the new fix, we have closed your ticket now. Feel free to contact us any time if you need further help or have some other issue or queries we will be happy to assist you soon.

Thank you.
8

The issues you have found earlier (filed as CELLSJAVA-41967) have been fixed in this update.

This message was posted using Notification2Forum from Downloads module by Aspose Notifier.