[Libreoffice-bugs] [Bug 128329] WORK: 'incomplete autocalculations' - cooperation of autocalculate and shared formulas / formulae still broken in LO calc ver. 6.2.7.1 with *threaded* calculation on

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=128329

bzdf.babri at neverbox.com changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
     Ever confirmed|0                           |1
             Status|UNCONFIRMED                 |NEW

--- Comment #2 from bzdf.babri at neverbox.com ---
Can confirm I am seeing this problem on:

Version: 6.3.3.2.0+
Build ID: 30(Build:2)
CPU threads: 4; OS: Linux 5.3; UI render: default; VCL: kde5; 
Locale: en-US (en_US.UTF-8); UI-Language: en-US
Calc:


Description:
The autocalculations seem to get stuck using threaded mode on a large
spreadsheet. All calculations complete successfully when threaded mode is
turned off.


Steps to Reproduce:

1. Retrieve this google sheet and save as xlsx format using
File->Download->Microsoft Excel (.xlsx):

https://docs.google.com/spreadsheets/d/1QGrMm6XSGWBVLI8I_DOAeJV5whoCnSdmaR8toQB2Jz8/edit#gid=0

2) Open the downloaded xlsx file with LibreOffice having "Enable multi-threaded
calculation" turned on under Tools->Options->LibreOffice->Calc

3) On the "StockBond Returns" sheet, see that cell T3465 displays "Err:522".
Click on cell T3465 and press F9 to recalculate. See that it's value is
recalculated correctly. Cells in the same column above still display "Err:522"

4) Click on cell T3464 and press F9 to recalculate. See that it's value and
many cells above it in the same column which previously showed "Err:522" are
now recalculated correctly.

5) See that cell T1742 and above still show "Err:522". Click on cell T1742 and
press F9 to recalculate. See that a few more rows above are recalculated
correctly. We can continue selecting cells and pressing F9 where the
calculations seem to get stuck and each time a few more rows get recalculated.

6) Turn off "Enable multi-threaded calculation" under
Tools->Options->LibreOffice->Calc and restart. Open same file and see that all
cells are calculated correctly. No cells display "Err:522".

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200210/d33f3ebf/attachment.htm>