Aspose Cells splitting sheet issue in different pages

[rutuja.mahajan]

Hi,

We are using Aspose Cells 23.1 with JDK version 8 on CentOS 7.

In converted PDF,

1. Page footer is overwriting the text on first page
2. Adding extra pages with blanks rows at the end.

Earlier I was using the setting opt.setOnePagePerSheet(true);
Now we don’t want one page per sheet, it should split sheet into different pages.
Q. Is there any criteria to split the sheet in pages (like X no of rows in one page)?

Please note that, I have generated this with my test program without setting license thats why it is showing evaluation header.

Attached Input/Output here,Aspose_Cells_Splitting_Sheet_In_Pages_Issue.zip (340.9 KB)

[simon.zhao]

@rutuja.mahajan
1，Can you share the locale setting of the machine that created this file ？
The default row height is strange 14.4pt in the file.
Could you resave the file in MS Excel, then export to pdf?
2, Adding extra pages with blanks rows at the end.
If you print the file in MS Excel, you will see same pages with blank rows.

[Amjad_Sahi]

In the mean time, after an initial test, we reproduced the issue with Input.xlsx file you mentioned. We found page footer is overwriting the text on first page.

To evaluate/investigate your issue, we have opened the following new ticket(s) in our internal issue tracking system and will deliver their fixes according to the terms mentioned in Free Support Policies.

Issue ID(s): CELLSJAVA-45099

You can obtain Paid Support services if you need support on a priority basis, along with the direct access to our Paid Support management team.

@rutuja.mahajan

Q. Is there any criteria to split the sheet in pages (like X no of rows in one page)

You can use page breaks feature to split your number of rows to be rendered on a page.