[Libreoffice-bugs] [Bug 129753] New: threaded and CL fail, erroneus results, autocalculate broken,

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 129753
           Summary: threaded and CL fail, erroneus results, autocalculate
                    broken,
           Product: LibreOffice
           Version: 5.0.0.5 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: newbie-02 at gmx.de

Description:
for the 'bug hunting session', 

the test from 

https://bugs.documentfoundation.org/show_bug.cgi?id=124577#c6

'minimum reproducer' still fails in ver: 

Version: 6.4.0.1 (x64)
Build ID: 1b6477b31f0334bd8620a96f0aeeb449b587be9f
CPU threads: 8; OS: Windows 6.1 Service Pack 1 Build 7601; UI render: default;
VCL: win; 
Locale: en-US (de_DE); UI-Language: en-US
Calc: threaded or CL

it works well if set to 'unthreaded' and! 'un-CL', if either of them is
activated it fails, 

strg-shift-F9 helps out, thus: 

- the sheet is computeable, 

- it's only autocalculate with a (new?) fail, 

i don't think 'use hard recalc' is an acceptable solution for users, 

the error is presenting wrong results, thus imho it's severe ... 

urgent suggestion: mark openCL and threaded as experimental while they are
buggy, 

reg. 

b. 

Steps to Reproduce:
1. check which options you have enabled, either 
-tools-options-libreoffice-opencl-allowuseofopencl-, or
-tools-options-libreoffice calc-calculate-enable multi-threaded calculation- 
will fail, both off will hold, 
2. open file https://bugs.documentfoundation.org/attachment.cgi?id=156818
3. select and copy B4:H4
4. paste in B5:H5
5. check result in H5: 21 is wrong, 30 is correct, 
6. trigger hard recalc, strg-shift-F9, see H5 changing, 
7. conclude 'auto calculated result was wrong'
8. believe me or not, there is a fundamental error in how calc handles
autocalc, shared formulas, dependencies and threading ... 

Actual Results:
H5 calculated to / or presented as 21, 

Expected Results:
H5: 30 as unthreaded or after hard recalc, 


Reproducible: Always


User Profile Reset: No



Additional Info:
Version: 6.4.0.1 (x64)
Build ID: 1b6477b31f0334bd8620a96f0aeeb449b587be9f
CPU threads: 8; OS: Windows 6.1 Service Pack 1 Build 7601; UI render: default;
VCL: win; 
Locale: en-US (de_DE); UI-Language: en-US
Calc: threaded

as ver. 5.0.0.1 fails too - plenty wrong results on load of this file with
openCL enabled, correctable with hard recalc, clean without openCL, i set first
affected to this ver. i'd bet all prior versions with openCL are affected too,

-- 
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/20200103/6ce98585/attachment.htm>