page count

Tue Feb 18, 2020 10:49 pm

I've found wrong value of Page count.
Below is my code, actual count is 5 but output is 4.

Spire.Xls.Workbook book = new Spire.Xls.Workbook();
book.LoadFromFile(@"D:\TEST_COUNT.XLSX");

var pageInfoList = book.GetSplitPageInfo();
int countPage = pageInfoList[0].Count;

MessageBox.Show(countPage.ToString());

book.Dispose();

Tue Feb 18, 2020 11:46 pm

I've tested latest version but result is wrong.

Wed Feb 19, 2020 2:48 am

Hi,

Thanks for your inquiry.
I have reproduced the issue and logged it with the ticket SPIREXLS-2139 in our bug tracking system. We will let you know once there is any update.

Sincerely,
Betsy
E-iceblue support team

Tue May 30, 2023 9:06 am

Hi,
I am having the same problem using the latest version of Java.
Is this problem the same with Java?
Has the ticket SPIREXLS-2139 been resolved?

Wed May 31, 2023 1:54 am

nid_shintaku wrote:Hi,
I am having the same problem using the latest version of Java.
Is this problem the same with Java?
Has the ticket SPIREXLS-2139 been resolved?

Hi,

Thanks for your inquiry.

We apologize for any inconvenience this may have caused.
We are glad to inform you that this issue has already been fixed in both Java and .NET. However, due to personnel changes within our organization, we inadvertently failed to notify some customers of the fix.

We have tested the latest version of our Java product and found that the page counts are accurate. In order to investigate the issue you are experiencing, we kindly ask you to provide us with your test document. This will help us to identify the problem and provide you with a solution as soon as possible. You can share it with via email (support@e-iceblue.com) or attach it here.

Thank you for your cooperation and understanding. Please let us know if you have any further questions or concerns.

Best regards,
Triste
E-iceblue support team

Wed May 31, 2023 2:00 am

kebby70 wrote:I've tested latest version but result is wrong.

Hi,

Thanks for your patience.
Due to personnel changes within our team, we inadvertently failed to notify you of the partial fix that was made to address the issue.

We are pleased to inform you that the issue SPIREXLS-2139 has been resolved, and we apologize for any inconvenience this may have caused. We appreciate your patience and understanding throughout this process.

Thank you for bringing this issue to our attention, and please do not hesitate to contact us if you have any further concerns or questions.

Best regards,
Triste
E-iceblue support team

Sun Jun 18, 2023 1:41 pm

Hi,

Thank you for your reply.
And sorry for the late reply.

I am using the Java version 13.5.2 and in my case I am having a problem with "workbook.getSplitPageInfo()" to get the correct number of pages in a sheet.
The Excel print preview shows 2 pages, but getSplitPageInfo() shows 3 pages, and the number of pages when converted to PDF is also 3.

I am attaching files with my case.

description.xlsx
It shows the difference in page count between the Excel print preview and the PDF.
sample.xlsx
This is the target Excel file. (generated by Spire.XLS for Java)
sample.pdf
The converted output PDF file.
sample_code.txt
This is an excerpt of the source code.

Please let us know if there are any coping methods or restrictions.

Mon Jun 19, 2023 2:45 am

Hi,

Thanks for your feedback.
After testing, I have reproduced this issue you mentioned, the page number is incorrect. I have logged this issue into our issue tracking system with the ticket number SPIREXLS-4761 and given this issue the highest priority. Sorry for the inconvenience caused, once the issue is fixed, I will inform you asap.

Best regards,
Triste
E-iceblue support team

Mon Jun 19, 2023 2:16 pm

Hi,

Thank you for your confirmation.
We hope it will be improved.

Tue Jun 20, 2023 1:41 am

Hi,

Thanks for your reply.
Once the issue is fixed, we will inform you asap. Sorry for the convenience caused.
If you have any other questions or concerns, just feel free to contact us. We appreciate your understanding and corporation!

Best regards,
Triste
E-iceblue support team

Tue Jul 18, 2023 9:19 am

Hi,

Thanks for your patience.
Glad to inform you that we just released Spire.Xls_13.7.3 for Java, which has fixed your issue SPIREXLS-4716, please download from the following link or Maven and have a test.
Website link: https://www.e-iceblue.com/Download/xls-for-java.html
Maven:

Code: Select all: <repositories> <repository> <id>com.e-iceblue</id> <name>e-iceblue</name> <url>https://repo.e-iceblue.com/nexus/content/groups/public/</url> </repository> </repositories> <dependencies> <dependency> <groupId>e-iceblue</groupId> <artifactId>spire.xls</artifactId> <version>13.7.3</version> </dependency> </dependencies>

Best regards,
Triste
E-iceblue support team