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

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #5 from b. <newbie-02 at gmx.de> ---
a hint?, a question ...

it looked interesting for me that this error is dependent of the sheet having
rows down to 103, the error is off once you delete row 103. 

by chance i stepped onto 'something' into an old version of calc with
experimental use of openCL (5.0.0.1): 

it has special settings when to use openCL, 'tools-options-LibreOffice
Calc-Formula-Detailed Calculation Setting-Minimum data size for OpenCL use' ... 

that setting defaults to 100 ... 

it's only an idea, but i'd bet 100 EUR 1:1 that this bugs (129753/124577)
behaviour needing a distinct number of rows to show up is a 'leftover' from
this setting still being somewhere in the code, as the range B4 to B103 has
exactly 100 cells, and thus anything triggered by testing if 100 formulas are
available for openCL use would step in. (the error doesn't show up if
parallelized calculation is switched off, it's supressed when less than 100
items are involved.)

symptom pointing in that direction: if you insert a row between 102 and 103 the
error is gone even with active openCL, if you create a second block of rows
with identical content below row 104 (former 103) it will work error free until
it's 101 rows long, after that dragging down row 105 to 204 gives wrong results
again. why 101 rows and copying the second? the top one has different formulas
referencing to row 102. 

this would / could mean that openCL (and threading?) are still buggy in
principle (in conjunction with 'shared formulas'?), but often - wrongly - are
considered 'fixed' because the tests are made with shorter blocks... ??? 

sorry @Eike, just 'assumptions' 

anyone to go for it?

-- 
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/20200122/d1436eb3/attachment-0001.htm>