Formula changes on running spire.xls

[KallindSoni]

i have a sheet with multiple IFERROR Formulas when i run spire on it even if i dont perform any changes on those cells for formula changes

example:
original: =IFERROR(AK12/AC12-1,"")

after spire: =@___rw3(AK12/AC12-1,"")

what to do, how to solve this issue?

[Tommy.Tang]

Hello,

Thanks for your inquiry.
I have tested the formula in the latest version of Spire.XLS for Python (Version:15.5.0), but didn't reproduce the issue you described. If you're not using the most recent version, I suggest that you give this one a try. If the issue persists, kindly share your test files and code samples to help us investigate further.
For confidential materials, you may securely send your file to [email protected]. We'll be glad to assist you upon receiving these details.

Sincerely,
Tommy
E-iceblue support team

[KallindSoni]

Hello Tommy,

I have mailed you the files which produced the issue. Just loading and saving the file is producing the issue, kindly test the files at your end.

Thank you

Code:
wb = Workbook()
wb.LoadFromFile('test/Test_Spire.xlsx')

wb.SaveToFile('test/demo.xlsx')

[Tommy.Tang]

Hello,

Sorry for the late reply due to the weekend.
I haven't received the files you sent to my email, could you please send them again? If your files are relatively large, we suggest that you upload them to the OneDrive server and share the download link with me. Thanks in advance.

Sincerely,
Tommy
E-iceblue support team

[KallindSoni]

Hello, the email did not go through since the files were large i had removed the outfiles and just attached screenshot of the error for your reference and re-sent the mail. you have replied on the mail so i hope files reached you well.

Replying here to keep things in loop

Thank you

[Tommy.Tang]

Hello,

Thanks for your files.
We have received the complete file you sent via email and will notify you of any progress as soon as possible. If you have any other questions later, please contact us in time. Thank you in advance.

Sincerely,
Tommy
E-iceblue support team

[KallindSoni]

Hi, are there any updates?

[Nina.Tang]

Hi,

Your issue has been successfully resolved and we will notify you promptly once the updated version is officially released. Please spare us a little more time, thanks for your understanding.

Sincerely,
Nina
E-iceblue support team

[KallindSoni]

Hello it's been almost a month. Are there any updates?

[Nina.Tang]

Hi,

Thanks for your patient waiting.
Glad to inform you that we just released the new version (Spire.XLS for Python Version:15.7.1) which fixed your reported issue. Please download it from the following link.
https://www.e-iceblue.com/Download/Spire-XLS-Python.html

Sincerely,
Nina
E-iceblue support team