Spire.XLS is a professional Excel API that enables developers to create, manage, manipulate, convert and print Excel worksheets. Get free and professional technical support for Spire.XLS for .NET, Java, Android, C++, Python.

Wed Mar 22, 2023 1:40 pm

Hello,
I'm converting XLSM file into PDF file using spire.office-8.3.5 API.
The attached sample file "Hecate Bidco_Draft_12.31.22 v1_Draft1_Non Libor.xlsm" has been converted (not perfectly) into pdf file but still it throws error like this. Also I do not know all the information have been properly converted.

The sample source code, log detail and converted pdf file are attached for your reference.
I appreciate your help on this.

InvalidFormula.zip
(1.93 MiB) Downloaded 400 times

UshaThavasiappan
 
Posts: 109
Joined: Sat Oct 08, 2022 9:23 am

Thu Mar 23, 2023 5:20 am

Hi,

Thank you for reporting the issue with our product. We appreciate the code and error logs you provided us with.
To help us pinpoint the issue accurately, could you please send us the input document that triggered the error? This will allow our development team to investigate the issue thoroughly and provide a prompt resolution.
Thank you for your cooperation and understanding in this matter. We look forward to hearing back from you soon.

Best regards,
Triste
E-iceblue support team
User avatar

Triste.Dai
 
Posts: 1000
Joined: Tue Nov 15, 2022 3:59 am

Thu Mar 23, 2023 9:19 am

Hi Triste,

Yes, I tried to upload the source file. But the upload limit size is exceeded (it is of 2.9MB)

If you suggest to share that file in any other mode, I will do the same.

UshaThavasiappan
 
Posts: 109
Joined: Sat Oct 08, 2022 9:23 am

Thu Mar 23, 2023 9:41 am

Hi,

Thanks for your feedback.
We appreciate your assistance in helping us identify and resolve issues.
I apologize that I did not communicate this clearly before, you can send the input document to us via email (support@e-iceblue.com) or share the download link with us. Thanks for your assistance and understanding.

Best regards,
Triste
E-iceblue support team
User avatar

Triste.Dai
 
Posts: 1000
Joined: Tue Nov 15, 2022 3:59 am

Thu Mar 23, 2023 12:00 pm

Hi,
I have shared the source file that causes error in the email.
Please have a look and take it forward.

UshaThavasiappan
 
Posts: 109
Joined: Sat Oct 08, 2022 9:23 am

Fri Mar 24, 2023 5:39 am

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-4574, 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
User avatar

Triste.Dai
 
Posts: 1000
Joined: Tue Nov 15, 2022 3:59 am

Fri Mar 24, 2023 7:12 am

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 ?

UshaThavasiappan
 
Posts: 109
Joined: Sat Oct 08, 2022 9:23 am

Fri Mar 24, 2023 10:14 am

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
User avatar

Triste.Dai
 
Posts: 1000
Joined: Tue Nov 15, 2022 3:59 am

Thu Mar 30, 2023 7:52 am

Hi,
Any update on this bug?

UshaThavasiappan
 
Posts: 109
Joined: Sat Oct 08, 2022 9:23 am

Thu Mar 30, 2023 9:50 am

Hi,

Thanks for your following-up.
We have investigated and successfully resolved the issue with the conversion process causing Invalid formula error. 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
User avatar

Triste.Dai
 
Posts: 1000
Joined: Tue Nov 15, 2022 3:59 am

Sat Apr 22, 2023 7:23 am

Hi Triste,
I downloaded the latest version 8.3.6 of Spire.Office API. I could not see the below mentioned issues are fixed in this version.

1. String index out of range error
2. Invalid formula error
3. NullPointerException: Can not read field

Please let me know

UshaThavasiappan
 
Posts: 109
Joined: Sat Oct 08, 2022 9:23 am

Sun Apr 23, 2023 3:54 am

Hi,

Thanks for your patience.
Please note that the Spire.Office for Java_8.3.6 was released on the 24th of last month, it did not include the fixes for your issues. But 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 and understanding 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
User avatar

Triste.Dai
 
Posts: 1000
Joined: Tue Nov 15, 2022 3:59 am

Mon Apr 24, 2023 9:37 am

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.

UshaThavasiappan
 
Posts: 109
Joined: Sat Oct 08, 2022 9:23 am

Tue Apr 25, 2023 6:22 am

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! :D

Best regards,
Triste
E-iceblue support team
User avatar

Triste.Dai
 
Posts: 1000
Joined: Tue Nov 15, 2022 3:59 am

Return to Spire.XLS