Chart divided when the page breaks

[UshaThavasiappan]

Hello,
Im converting excel file into pdf using spire.office-7.10.1

After conversion of the file "sales-forecast.xlsx" file, the last chart from the "Charts" sheet is splitted into two when the current page is exceeded to next page. But I do not want to convert the entire sheet in a single page since, the a sheet may contain n-number of rows.

Sample program, sample source and converted file with screenshot of an issue are attached for your reference.

I really appreciate your help on this.

SplitChartIssue.zip

(510.33 KiB) Downloaded 207 times

[Abel.He]

Hello,

Thanks for your inquiry.
For your requirement, you can add the following code snippet:

Code: Select all

workbook.getConverterSetting().setSheetFitToPage(true);

If you have any issue, just feel free to contact us.

Sincerely
Abel
E-iceblue support team

[Abel.He]

Hello,

Hope you are doing well.
Could you give some feedback about this issue? Looking forward to your reply.

Sincerely
Abel
E-iceblue support team

[UshaThavasiappan]

Hello Abel,
Sorry for the response delay, I was on long break.

It works for a sheet with minimal data. For example, I have a sheet containing 1000s of rows data. The whole sheet will be converted into a single page.
Actually, I do not want to convert entire sheet in a single page. That is I mentioned in the ticket description.
Could you please suggest alternate for this?

Also I want to know the status of the following bug. When can I get the fix for these bugs?
We are planning to purchase Spire.Office product. If I have a clear ETA for these bugs, I can ask my higher-up to purchase this confidently.

SPIREXLS-4166
SPIREXLS-4179
SPIREXLS-4233
SPIREXLS-4208
SPIREXLS-4237

Im hoping for the solutions

[daisy.zhang]

1

[Abel.He]

Hello,

Thanks for your feedback.
Sorry for that there is no way to keep the chart intact while converting sheet to multipage pdf file.
1) SPIREXLS-4166、SPIREXLS-4208: These issues have been in test phase.

2) SPIREXLS-4233: My colleage lisa has provided solution in forum post(partial-data-display-issue-when-cell-has-multi-lines-of-data-t11638.html).

3) SPIREXLS-4237: I have make replied to this issue in forum post(number-amount-values-are-not-converted-properly-t11650.html).

4) SPIREXLS-4208: This issue has been solved in Spire.Xls12.10.3, you can download it from the following link:
https://www.e-iceblue.com/Download/xls-for-java.html

Sincerely
Abel
E-iceblue support team

[UshaThavasiappan]

Hello,
Could you please update the bugs status.

SPIREXLS-4166
SPIREXLS-4179
SPIREXLS-4208

[Abel.He]

Hello,

Thanks for your following-up.
These issues with SPIREXLS-4166 and SPIREXLS-4208 has passed the test phase, and the official version including these fixes will be released after 10 days.

The issue with SPIREXLS-4179 has been fixed in Spire.Xls_12.10.3, you can download it from the following link.
Website download link: https://www.e-iceblue.com/Download/xls-for-java.html

Sincerely
Abel
E-iceblue support team

[UshaThavasiappan]

Hello,
Thank you.
We have purchased Spire.Office API. Is SPIREXLS-4179 bug fix available on the latest version 7.11.2 ?

Also please notify me once other two bugs are fixed.
May I get a notification for the latest Spire.Office version release ?

[Abel.He]

Hello,

Thanks for your feedback.
Is SPIREXLS-4179 bug fix available on the latest version 7.11.2 ?
The issue with the number SPIREXLS-4179 has been fixed on the latest version 7.11.2. You can download it from the following link.

https://www.e-iceblue.com/Download/office-for-java.html

May I get a notification for the latest Spire.Office version release ?
Okey, once the official Spire.Office including the fixes of your issues is released, I’ll inform you in time.

Sincerely
Abel
E-iceblue support team