While converting Excel workbook into PDF- the output generated by Aspose has more number of pages

Aspose.Cells Product Family
1

Hi All,


I am using Aspose Cells 7.3.0.3 for Java to convert an excel workbook into PDF. The sample Excel workbook I am attaching here is of 1 page ( Excel > Print > Print Preview shows only 1 page too).

When I convert it to PDF using Aspose, the output PDF is of 2 Pages.
When I convert it to PDF using Excel (Save As), the output PDF is of only 1 page.

Due to this, the size of the PDF increases considerably for large excel worksheets. Is there a way we can make sure that the number of pages in the PDF file generated by Aspose is same as the number of pages generated using Excel?

Thanks,
Smitha

2

Hi Smitha,


Thanks for providing us the template files.

I can find the issue as you have mentioned by converting your template file “Book2.xlsx” to PDF format. The output PDF has 2 pages instead of 1.

Sample code:

String path = “Book2.xlsx”;
Workbook workbook = new Workbook(path);
workbook.save(path + “.out.pdf”, SaveFormat.PDF);

I have logged a ticket with an id: CELLSJAVA-40283. We will look into it soon.

Thank you.
3

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

This message was posted using Notification2Forum from Downloads module by aspose.notifier.
4

This severity of the problem we faced is reduced with the fix, But i still see that the PDF generated by Aspose has more number of pages when compared to the PDF directly generated by Excel. I see this problem consistently with Excel workbooks having huge tables that cover more than 10 pages.


I will attach a sample shortly.

Thanks,
Smitha
5

Hi Smitha,


Sure thing, kindly do attach your Excel file(s) and output PDF file(s) for the issue, we will check your issue soon.

Thank you.
6

Hi Amjad,


I am attaching the sample excel worksheet along with the output PDF generated with excel and aspose. The PDF generated with Aspose takes 1 extra page for a 16 page document. I could reproduce the same problem with a 54 page workbook where Aspose output PDF takes 2 -3 more pages.

Thanks,
Smitha
7

Hi Smitha,


Thanks for providing the files.

Yes, you are right, I can notice the issue, it renders 17 pages i.e. should render 16 pages — one page is rendered as extra. I have reopened your issue again, we will soon look into it to figure it out.

Thank you.
8

Any updates on this?


Thanks,
Shikha
9

Hi Shikha,

Thanks for your posting and using Aspose.Cells for Java.

I have checked your issue with the latest version: Aspose.Cells
for Java v7.7.0.3 and issue still exists.

We have logged your comment in our database and requested the development team to provide some ETA or update for this issue. Once, there is some fix or update for you, we will let you know asap.