Hello. We're currently facing an issue with running the CalculateAllValue() method. Unfortunately we can't provide the input data due to confidentiality reasons.
The code itself is fairly basic. We're filling out some excel sheets then we call the CalculateAllValue() method to fill out the values inside the remaining sheets of the file, which rely on formulas and the pre-filled data.
The code also runs fine when doing this for a single file. However, the processing happens in a loop consisting of several files and for some files this call fails with a Stack Overflow exception.
The version we're using is SpireXLS for .net 8.3.8.
The environment is Windows. It's reproducible on both the servers (Windows Server 2016) as well as our machines, (W10).
The application type is a Console app (.net framework 4.5.2)
The exception itself is thrown within the SpireXLS library so we're wondering whether you know of any common situations where this might happen.
The development machines as well as the server are equipped with 16GB of RAM and the data sets are under 100MB.
Thank you for any ideas or suggestions you might have.
Hello,
Thank you for your inquiry and for providing the information regarding the issue you are experiencing.
I have noticed that you are currently using an older version of Spire.XLS, which is dated back to 6 years ago. It is important to note that the current version of Spire.XLS is Pack Version:14.1, which includes more fixes and new features compared to the version you are using.
To ensure the best performance and stability of your application, I highly recommend upgrading to the latest version of Spire.XLS. Once you have completed the upgrade, please re-test your application to see if the issue persists.
If the issue still exists after upgrading to the latest version, please provide us with your complete test code and test documents (with sensitive data removed) so that we can further investigate the matter. You could attach them here or send them to us via email (support@e-iceblue.com). Thanks in advance.
Sincerely,
Annika
E-iceblue support team
Thank you for your inquiry and for providing the information regarding the issue you are experiencing.
I have noticed that you are currently using an older version of Spire.XLS, which is dated back to 6 years ago. It is important to note that the current version of Spire.XLS is Pack Version:14.1, which includes more fixes and new features compared to the version you are using.
To ensure the best performance and stability of your application, I highly recommend upgrading to the latest version of Spire.XLS. Once you have completed the upgrade, please re-test your application to see if the issue persists.
If the issue still exists after upgrading to the latest version, please provide us with your complete test code and test documents (with sensitive data removed) so that we can further investigate the matter. You could attach them here or send them to us via email (support@e-iceblue.com). Thanks in advance.
Sincerely,
Annika
E-iceblue support team
-
Annika.Zhou - Posts: 1657
- Joined: Wed Apr 07, 2021 2:50 am
Page 1 of 1