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 v18.104.22.168 and see if it makes any difference and resolves your issue.
Let us know your feedback.
What are the changes between 22.214.171.124 and 126.96.36.199?
Ok, my code now works with 188.8.131.52. I would still like to know the differences between that and 184.108.40.206. 220.127.116.11 doesn’t seem to be an official release?