Xlsx to pdf has wrong page numbers

Aspose.Cells Product Family
1

Hi,
I converted the attached xlsx to pdf and noticed that the page numbering of pdf is wrong. We would also like an option to have a consolidated page number for the generated pdf like 1 of 7, 2 of 7, etc instead of 1of3, 2 of 3, 3 of 3, 1 of 4, 2 of 4, 3 of 4, 4 of 4. .
Thanks & Regards,
Vimal

2

Hi,

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

I have converted your xls file into pdf and I was able to found the problem as you have mentioned. Pages numbers are not correct. I have used the latest version:
Aspose.Cells
for Java v7.3.0.4

I have logged this issue in our database. We will look into it and fix the problems. Once the issue is fixed or we have some other update for you , we will let you know asap.

This issue has been logged as CELLSJAVA-40287.

Java


String path = “F:\Shak-Data-RW\Downloads\PEC-EN-GDE-M-5112.xlsx”;


Workbook workbook = new Workbook(path);

workbook.save(path + “.out.pdf”, SaveFormat.PDF);


3

Hi,

Thanks for using Aspose.Cells for Java.

We have further looked into this issue and found that it is because of your wrong footer settings. Please see the screenshot below.

So please correct your footer i.e "Page &[Page] of &[Pages]"

It will resolve your problem.

Screenshot:

4

Hi Faiz,
I see what the problem is now. Thank you for the explanation.
Thanks & Regards,
Vimal

5

Hi,

It’s good to know that you now know the source of problem regarding this issue.

If you have any other question, please feel free to let us know, we will assist you further.