We are running into a bug where a call to CalculateFormula hangs. Attached is a zip file, “CalculateFormulaHang.zip”, and inside is an Excel file that was created by Aspose, and some test code.
In order to reproduce, do NOT save the Excel after opening in Excel. This actually corrects the problem.
The test code implements the AbstractCalculationMonitor and logs information so you can see which formula calculation hangs.
After an initial test, I was able to reproduce the issue as you mentioned by using your template Excel file. I found Workbook.CalculateFormula hangs indefinitely with latest version of Aspose.Cells for .NET.
We require thorough evaluation of your issue. We have opened the following new ticket(s) in our internal issue tracking system and will deliver their fixes according to the terms mentioned in Free Support Policies.
Issue ID(s): CELLSNET-54720
You can obtain Paid Support Services if you need support on a priority basis, along with the direct access to our Paid Support management team.
We are pleased to inform you that your issue has been resolved. The fix will be included in our upcoming release (Aspose.Cells v23.12) that we plan to release in the next week. You will be notified when the next version is published.
The issues you have found earlier (filed as CELLSNET-54720) have been fixed in this update. This message was posted using Bugs notification tool by johnson.shi