Hello. I have a piece of code that opens excel workbooks, reads some information out of them, and then closes them. When I run it on a single thread, it works just fine. However, when I run multiple workbooks in parallel, I get a CellsException when I call Workbook.CalculateFormula ("…Invalid formula: More than one token in stack"). I am opening the workbook using a Stream. The Stream is NOT shared between threads. Each thread creates a new stream and is backed by a new byte buffer. The threads also do NOT share workbooks. The workbooks are new-ed up within instances of classes that are new-ed up one per thread.
Thanks for your posting and using Aspose.Cells.
It should work fine as per your approach because you are not sharing the workbook. Please provide us your runnable console application replicating this issue. We will run it at our end and log this issue in our database for a fix.
Please also download and try the latest version: Aspose.Cells
for .NET v184.108.40.206 and see if it makes any difference and resolves your issue.
Let us know your feedback.
What are the changes between 220.127.116.11 and 18.104.22.168?
Ok, my code now works with 22.214.171.124. I would still like to know the differences between that and 126.96.36.199. 188.8.131.52 doesn’t seem to be an official release?