NullPointerException: Can not read field

[UshaThavasiappan]

Hello,
I'm converting XLSB file into PDF file using Java spire.office-8.3.5 API.
The source file "Portfolio Valuation Model- Permira_Dec 22_Omnicare.xlsm" has been ended in error without converting a file.

java.lang.NullPointerException: Cannot read field "spr‰" because the return value of "com.spire.xls.core.converter.spreadsheet.extensions.ExternalSheetCollection.spr⌹—(int)" is null
at com.spire.xls.core.converter.spreadsheet.extensions.ExternalSheetCollection.spr╋┈(Unknown Source)
at com.spire.office.packages.sprdyf.spr㈬⃝│(Unknown Source)
at com.spire.office.packages.sprdyf.spr⑉│(Unknown Source)
at com.spire.office.packages.sprdyf.spr⑉│(Unknown Source)

The error line shows this code

Code: Select all

if (worksheet.getPivotTables().getCount() == 0) {
    worksheet.CalculateAllValue();
}

This code has been given from the support team to resolve one of my issues. I tried commenting this code and execute this and end up with the same error on saving to file.

The sample source code and screenshot of the log detail are attached for your reference.
I could not upload the source file in this thread. I will share the same to the support email.

I appreciate your help on this.

Permira-NullPointer.zip

(32.79 KiB) Downloaded 385 times

[Triste.Dai]

Hi,

Thank you for reporting the issue in our Spire.XLS. We take all issues seriously and strive to resolve them as quickly as possible.
After testing, we were able to replicate the issue that you reported. I have logged this issue into our issue tracking system with the ticket number SPIREXLS-4577, our development team is now working on a fix, and we will provide an update as soon as it becomes available. Sorry for the inconvenience caused.

Best regards,
Triste
E-iceblue support team

[UshaThavasiappan]

Hi Triste,
Thanks for considering my issue as a bug.
I'm responsible to the business. Could you please provide me ETA for this bug fix ?

[Triste.Dai]

Hi，

Thank you for reaching out to us regarding the issues in our Spire.XLS. We appreciate your involvement and concern in this matter.
I regret to inform you that we are unable to provide an estimated time of arrival for these fixes at this moment. However, please be assured that we have assigned the highest priority to them, and our development team is working diligently to resolve it as quickly as possible.
We understand that these issues are causing inconvenience for you, and we apologize for any frustration it may have caused. We will keep you updated on the progress and let you know as soon as we have more information.
Thank you for your patience and understanding.

Best regards,
Triste
E-iceblue suppport team

[UshaThavasiappan]

Hi,
Any update on this bug?

[Triste.Dai]

Hi,

Thanks for your following-up.
We have investigated and successfully resolved the issue with the conversion process causing NullPointerException. Once the new version is released, we will notify you asap.
Please let us know if you have any further concerns or other questions.

Best regards,
Triste
E-iceblue support team

[Triste.Dai]

Hi,

We are pleased to inform you that we just released Spire.Office for Java_8.4.5, which has fixed your issue SPIREXLS-4574, SPIREXLS-4576 and SPIREXLS-4577, please download the new version from the following links and have a test.
Website link: https://www.e-iceblue.com/Download/office-for-java.html
Maven Repository:

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.office</artifactId>
        <version>8.4.5</version>
    </dependency>
</dependencies>

Thanks for your patience during this process, please do not hesitate to reach out to us if you have any further questions or concerns.

Best regards,
Triste
E-iceblue support team

[UshaThavasiappan]

Hi Triste,
I checked the latest version 8.4.5 of Spire.Office API for Java and the issue for the mentioned file has been fixed.

[Triste.Dai]

Hi,

Thanks for your feedback.
Glad to hear that your issue was solved, please do not hesitate to reach out to us if you have any further questions or concerns.

Have a nice day!

Best regards,
Triste
E-iceblue support team