XLSX to PDF conversion throws ClassCastException

[UshaThavasiappan]

ConvertXlsxToPdf.zip

Source code with sample Xlsx file

(140.37 KiB) Downloaded 165 times

Hello Experts,
Im converting XLSX file into PDF file using spire.xls-12.9.1 API. Im getting the below ClassCastException while executing workbook.saveToFile() function (ConvertExcel.java:37).
Sample code and sample source file attached for your reference.

java.lang.ClassCastException: class java.lang.Integer cannot be cast to class com.spire.xls.packages.sproyf (java.lang.Integer is in module java.base of loader 'bootstrap'; com.spire.xls.packages.sproyf is in unnamed module of loader 'app')
at com.spire.xls.packages.sprdhf.spr▓⑆(Unknown Source)
at com.spire.xls.packages.sprdcf.spr◐⑇(Unknown Source)
at com.spire.xls.packages.sprdcf.spr⌬⑇(Unknown Source)
at com.spire.xls.packages.sprdcf.spr⌬⑇(Unknown Source)
at com.spire.xls.packages.sprdcf.spr¬⑉(Unknown Source)
at com.spire.xls.packages.sprdcf.spr⑄⑀(Unknown Source)
at com.spire.xls.packages.sprtxe.spr⑄⑀(Unknown Source)
at com.spire.xls.packages.sprajj.spr⑫╄(Unknown Source)
at com.spire.xls.packages.sprajj.spr※⌨(Unknown Source)
at com.spire.xls.core.spreadsheet.XlsWorkbook.spr※⌨(Unknown Source)
at com.spire.xls.core.spreadsheet.XlsWorkbook.spr≇⌨(Unknown Source)
at com.spire.xls.Workbook.saveToFile(Unknown Source)
at com.chainsys.xlstopdf.ConvertExcel.main(ConvertExcel.java:37)

I appreciate your help on this.

[kylie.tian]

Hi,

Thank you for your inquiry.
I reproduced your problem and posted it to our bug tracking system with the problem number SPIREXLS-4166. I will let you know as soon as the issue is resolved or there is any update. Sorry for the inconvenience.

Sincerely,
Kylie
E-iceblue support team

[UshaThavasiappan]

Hi Kylie,

Thanks for your response.
Kindly update me. Thanks

[UshaThavasiappan]

Hello Kylie,
Actually my company is planning to purchase this Spire.Xls product. Can you clarify the below points

1. I have reported 2 bugs (SPIREXLS-4166 & SPIREXLS-4179) as of now, will that be available after purchase once the bugs are resolved.
2. May I know the pricing details
3. After purchasing, if any bugs are reported or for any assistance, is that be inclusive or how ?

[kylie.tian]

Hi,

Here is my answers to your questions.
1.Our dev team has adjusted the SPIREXLS-4179 and it is going to the test stage now. If the test goes well, we will provide a hotfix asap. Sorry there is no update on the SPIREXLS-4166 at present, I have given your issue a high priority and urged our dev team to speed up the search for solutions. If there is any meaningful progress, I will let you know immediately. Thanks for your understanding.
2.Regarding the cost of the Spire.XLS for NET, please check the price details of Spire.XLS as below:
https://www.e-iceblue.com/Buy/Spire.XLS.html
How to choose the right subscription:
https://www.e-iceblue.com/Misc/purchase-policies.html
3. If you encounter any problems in the process of using our products, you can contact us at any time. We will look into it and help you out.
Kindly note that our license is based on one year subscription. The 1-year subscription enables free priority support and updates for one year, after the subscription expires, you can still use the licensed version of the product, but the new releases and hotfixes are no longer available. In other word, if the new version that contains the fixes of the bugs you reported is within the authorized time of your license, you can upgrade the version for free.

Sincerely,
Kylie
E-iceblue support team

[UshaThavasiappan]

Hello,

Thanks for the detailed explanation of pricing and subscription. I will take it forward from my side.

[UshaThavasiappan]

Hello,
Any update on the ticket SPIREXLS-4166 ?

[kylie.tian]

Hi,

Our dev team has adjusted the SPIREXLS-4166 problem and it is going to the test stage. If the test goes well, we will provide a hotfix asap. I'll let you know as soon as there is any meaningful progress.
In addition, the SPIREXLS-4179 issue has been resolved, but the official version is not available at present. Once the official version is released, I will inform you ASAP. Thanks for your understanding.

Sincerely,
Kylie
E-iceblue support team

[Nina.Tang]

Hi,

Thanks for your patient waiting.
Glad to inform you that the reported bug SPIREXLS-4166 and SPIREXLS-4179 have been resolved and the new version is released. Please download the Spire.XLS for Java Version:12.11.8 from this link.
https://www.e-iceblue.com/Download/xls-for-java.html

And add the code below before saving to test.

Code: Select all

workbook.getConverterSetting().isReCalculateOnConvert(false);

Sincerely,
Nina
E-iceblue support team

[UshaThavasiappan]

Hi,
Thanks for the update. I will check this out using Spire.XLS
we purchased office for our organization. Is this fix available in Spire.Office ?

Also I just want to confirm the mentioned code will not affect other formatted codes.

workbook.getConverterSetting().isReCalculateOnConvert(false);

[Nina.Tang]

Hi,

Thanks for your feedback.
The next Spire.Office will contain the fix of your issue. Once the version is released, I will inform you.
When converting Excel to PDF, our product will calculate values automatically. Setting isReCalculateOnConvert to false will prevent automatic calculation. Your Excel file contains the Pivot Table slicer, it is not supported by our product when converting at present. Hence, you need to set the isReCalculateOnConvert to false to keep the data of your Excel, otherwise, the data will be calculated incorrectly. Don't worry, this method will not affect your other codes.

Sincerely,
Nina
E-iceblue support team

[UshaThavasiappan]

Thanks for the clarification

[Abel.He]

Hello,

Thanks for your patience!
Glad to inform you that we just released Spire.Office7.12.2 which fixes these issues with SPIREXLS-4166 and SPIREXLS-4250.
Please download the new version from the following links to test.
Website download link: https://www.e-iceblue.com/Download/office-for-java.html

Sincerely
Abel
E-iceblue support team

[UshaThavasiappan]

Hello,
Thanks for your reply.
I will check this out and back to you if I have any issues.

[Abel.He]

Ok, once there are any issue, we always here to support you.

Sincerely
Abel
E-iceblue support team