String index out of range error

Thu Mar 23, 2023 12:39 pm

Hello,
I'm converting XLSB file into PDF file using Java spire.office-8.3.5 API.
The source file "ERM_November22_SJP_v2.xlsb" has been ended in error without converting a file.

java.lang.StringIndexOutOfBoundsException: String index out of range: 59
at java.base/java.lang.StringLatin1.charAt(StringLatin1.java:48)
at java.base/java.lang.String.charAt(String.java:1515)

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.

ERM-StringIndexError.zip: (34.15 KiB) Downloaded 406 times

Fri Mar 24, 2023 5:40 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-4576, 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

Fri Mar 24, 2023 7:08 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 ?

Fri Mar 24, 2023 10:17 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

Thu Mar 30, 2023 7:49 am

Hi,
Any update on this bug?

Thu Mar 30, 2023 9:53 am

Hi,

Thanks for your following-up.
We have investigated and successfully resolved the issue with the conversion process causing String index out of range exception. 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

Mon Apr 03, 2023 6:49 am

Hi Triste,
Thanks much for your support and for the engineering team.
May I know the ETA for the new version ?
If this will take time to be on public, may I get temp version to check myside for all the below mentioned bugs ?

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

Mon Apr 03, 2023 7:30 am

Hi,

Thank you for contacting us regarding the release of a new version with issue fixes. Unfortunately, we cannot provide an exact release date for the next version at this time. However, we understand your urgency to have the issue resolved and will provide you with a temporary version as soon as possible.

Our testing team is currently working on packaging the temporary version for you. As the Office package contains several products, it may take some time to complete the process. We appreciate your patience in this matter and anticipate that we will provide you with a download link for the temporary version tomorrow.

Please let us know if you require any further assistance or have any other concerns.

Best regards,
Triste
E-iceblue support team

Mon Apr 03, 2023 8:53 am

Hi,

We are pleased to inform you that the temporary version for testing is now available. Please download it using the following link: https://www.e-iceblue.com/downloads/TempVersion/java/Spire.Office_8.4.0_xls1.zip

Please note that the temporary version is intended for testing propose and there may be some formula calculation issues with the resulting documents due to referencing incorrect cells or using invalid methods. However, to avoid this problem, you can set the conversion process to not recalculate formulas, please refer to this post: https://www.e-iceblue.com/forum/the-converted-file-have-incorrect-data-t12084.html.

If you have any further questions or concerns regarding this temporary version, please do not hesitate to contact us.

Best regards,
Triste
E-iceblue support team

Tue Apr 04, 2023 8:54 am

Hi,
Thanks for sharing the temp version. I will check my sample files and let you know the results.

Sun Apr 23, 2023 4:18 am

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

Mon Apr 24, 2023 9:36 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.

But I'm getting the same error for the below attached file.

LG Template_Aspen_Q3 2022_Final.zip: (819.56 KiB) Downloaded 364 times

Tue Apr 25, 2023 6:15 am

Hi,

Thanks for your feedback.
After testing, I have reproduced the issue you mentioned and logged it into our issue tracking system with the ticket number SPIREXLS-4635, our developers will investigate and fix this issue, apologize for any inconvenience caused, once the issue is fixed, I will inform you asap.
Thanks for your understanding.

Best regards,
Triste
E-iceblue support team

Sat May 06, 2023 2:30 am

Hi,

Glad to inform you that our development team has investigated and resolved the two issues.
However, we have noticed that the conversion results may not meet your expectations. I uploaded the result documents to our server and shared the download link with you via email, please download and have a look. If there are any specific areas that require optimization or improvement, please let us know. Our developers will work on further improvements and fixes.

We appreciate your continued support and feedback as we strive to provide the best product possible.

Best regards,
Triste
E-iceblue support team

Mon May 08, 2023 11:57 am

Hi Triste,
Thanks for the update. Good to hear that two issues are resolved.
I have gone through the resultant files, it seems good to me.
When can I expect the new release with this fix ?
Also for the data conversion issue, what is your solution / suggestion / workaround ?