[Libreoffice-bugs] [Bug 125320] - sporadic fail! - combination of autocalculate and shared formulae still broken in 6.3.0.0.alpha1+ with threaded off

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #9 from b. <newbie-02 at gmx.de> ---
@Telesto, 

thanks for your understanding words, 

no, the original report shouldn't be closed, as said there: 'the error happens
in rare cases and in large sheets', 

thus two or three 'non-repros' are only an indication that it could work
without errors, and that is inherent in the OP, thus nothing changed, 

statistically (i know that this is not an exact science) there are methods to
tell if 'probably' something is different or not, depending on the frequency of
an 'event' and the frequency in a certain sample, 

i am not a mathematician or statistician, but i would think that if there was
an earlier occurrence of maybe once in a thousand operations, it would take
about three to four thousand negative tests to have a significant significance
that something has changed, 

we do not have them and we cannot afford them, 

possibility one: implement a 'control system' in calc similar to what you do
for airplanes or other important tasks, comparative calculations on another
way, if the results match, you have a good chance that they are correct, if
they don't, you - mostly - have a reproducible error, 

option two: try, try, try until you find a reproducer, 'please users: save your
files, then do a recalc and compare the results, if error pls. report',

option three: put aside as 'no-repro' as it's actual practice, 

option four: mathematical - logical analysis of all program functions ... much
work, 

possibility five: rewrite calc and hope for fewer errors, 

possibility five-a: do that in chunks, for e.g. our nice problem fields
'comments' or 'copy/paste' or 'iterations' ... instead of more and more patches
in the existing system ... write a replacement, implement an option to toggle
between them, once the new works better delete the old scrap,  

option six: someone else could come up with something better, 

option seven: 'hard recalc' helps in many cases, we simply explain hard recalc
from 'control' to calculation mechanism, 

option eight: use other spreadsheets like ex$el or go$gle and hope for other or
less bugs, 

option eight-a: use other spreadsheets as a control mechanism for option one,
the data is sent online to M$ and google in the background and calculated with
'sheets' or '365', do the results match ... 

i have been working on some 'hard repro' bugs, i mean most of them were due to
'shared formulas', if it wasn't too small on my screen i would probably go back
to version 4.1, you see from above that i'm quite frustrated, 

i do have a lot of understanding that this also affects many developers, 

and my frustration will grow if @xisco closes this comment as 'no value' ... 

P.S. retested 
'deleting the contents in the sheet, pasting in 5 rows and pulling A1:CZ5 down
to 1300 inserting the same values in row 1300 produced faulty '0' only in rows
1 to 5.' 
pasting in a copy of row 1, but pulled down to row 1365, repro in 6.1.6.3,
norepro in 7.1 from 2020-20-04, there is hope that something changed, but
nothing conclusive ...

-- 
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/20201014/43f150b5/attachment.htm>