Thanks for trying. If you use multi-threading in your big application, you have to ensure that a single Workbook is never used in multiple threads at the same time. POI ensures that global/static caches are synchronized, but work on a single Workbook is not synchronized, so you should synchronize in your code if that could be related
I have prepared a small change which avoid cases where sheets are added while FormulaEvaluator is in use. Unfortunately it will not make it into 5.1.0. So as far as I see your best bet for now is to check for multi-threaded access and maybe use "clearAllCachedResultValues()" before evaluating formulas. Thanks... Dominik. On Sat, Oct 30, 2021 at 4:28 PM Andreas Reichel < andr...@manticore-projects.com> wrote: > Dominik and Team, > > I did my very best to create an isolated Test Case. > The attached file does exactly what I do in the production (without > database, formatting and less formulas). But for whatever reason it never > triggers the Exception. > > The flow and the business logic is exactly the same. Only difference is: > in the production I read the Detail Sheet from a Database and do rather > large Cash Flow Calculations instead just adding 2 numbers. > Without the database it is useless though. > > I do understand that without a reproducible test, nobody can debug the > problem. So I can only leave that open for now and would return if I was > able to get more information. > > Warm regards > Andreas > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: user-unsubscr...@poi.apache.org > For additional commands, e-mail: user-h...@poi.apache.org
