The converted file have incorrect data

Thu Mar 23, 2023 2:10 pm

Hello,
I'm converting XLSB file into PDF file using Java spire.office-8.3.5 API.
The source file "Ivanti Software_Draft_12.31.2022_v1_Libor.xlsm" has been converted into pdf format. But the converted file is having many data issues like a cell value is calculated / taken from other sheet's cell value in the same workbook.

Many tabs are having this kind of error. But I have mentioned some of the tabs in the screenshot.

The sample source code and screenshot of the errors 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.

Ivanti-IssueScreenshots.zip: (381.8 KiB) Downloaded 439 times

Ivanti-ConvertedFile.zip: (1.79 MiB) Downloaded 387 times

Fri Mar 24, 2023 5:42 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-4580, 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:09 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 7:11 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:15 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:50 am

Hi,
Any update on this bug?

Thu Mar 30, 2023 9:35 am

Hi,

Thanks for your following-up.
Our development team has investigated the issue and found that the three images you attached with incorrect calculations were all nested within the "AD201" cell of the "Loan Model" worksheet, which contains an invalid method called ciqfunctions.udf.CIQ. As a result, the calculations were incorrect. Similarly, other areas where calculation errors occurred were also due to incorrect method references.
We have also found that even when the document is opened and recalculated in Excel, these cells still produce incorrect results.

However, we can offer a solution to provide the original, unrecalculated results by adjusting the conversion process settings. Please refer to the following picture:

: approach.png (39.7 KiB) Viewed 1127 times

Please let us know if you have any further concerns.

Best regards,
Triste
E-iceblue support team

Tue Apr 04, 2023 12:58 pm

Hi,
These 2 piece of code will be shared by your tech team for one of my bugs.
If I do the mentioned changes, I can get the result what I expected.
But the previous fixed issues are reopened like age calculations and one more issue

Thu Apr 06, 2023 8:41 am

Hi,

Thanks for your feedback.
Regarding the first issue, could you please confirm that the result document "hockeyplayerdata2018.pdf" contains error value in the "age" column of the "PlayerData" page?

For the second issue, we would appreciate if you could provide us with more details or screenshots to help us better understand the issue at hand. Once we have more information, we will be able to investigate the matter and provide a solution as soon as possible.
Thanks for your assistance.

Best regards,
Triste
E-iceblue support team