Multi-thread calculation is now supported in Calc. This feature is enabled by default. This is a good thing, but at some rare corner cases this feature may cause trouble because of bugs. For example, I can not go on with my work or further testing because of bug 114157. Thus I suggest to add an option in Calc to let the user manually disable Threaded Calculation.
I assume the expert configuration item UseThreadedCalculationForFormulaGroups that was added in the commit enabling parallel calculation does that.
Ok will check if it works
You are correct. If I go to Tools - Options - LibreOffice - Advanced - Expert Configuration, then search for "Thread", then I see "UseThreadedCalculationForFormulaGroups" which is a bool option. If I set this to False then restart, bug 114157 is gone. Set is WORKSFORME.
Thanks for testing and verifying. Adjusting status to FIXED, since the commit introducing the option has been identified. https://cgit.freedesktop.org/libreoffice/core/commit/?id=5222910f969390c64c18866834d9af53e7c4c189 author Tor Lillqvist <tml@collabora.com> 2017-10-04 12:40:20 +0300 committer Dennis Francis <dennis.francis@collabora.co.uk> 2017-11-21 16:09:42 +0530 Make threaded calculation the default (when OpenCL is not used)