[Libreoffice-bugs] [Bug 129199] AutoCalculate silent, deceptive fail. Indicative pattern of one edit step lag in AC update noticed.

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #5 from b. <newbie-02 at gmx.de> ---
@R. Bingham

many many many thanks, i think it's a great achievement that you've seen this
hidden bug, clearly documented it, and beautifully expressed how nasty such
things can mislead users. 

@all

They remain - unfortunately - undiscovered for years, and none of us can
estimate how many wrong results led to wrong decisions or constructions, from
wrong paychecks up to airplane crashes. 

An example might be bridge constructions, where iterations are necessary as a
weight has to be carried, material is required to do that, it increases the
weight to be carried by its own weight, and it has to be recalculated how much
material in which strength is neccessary to achieve sufficient stability.
Errors in such calculations can hardly be detected with a calculator or pencil
and paper. 

We've had tragic bridge collapses recently?

For this reason I argue in another matter - 'autocalculate broken by shared
formulas' - since a long time for a more reliable processing, unfortunately
with little success so far. 

Observations on this problem: 

in earlier versions the error doesn't show up (4.1.6.2 and 5.0.0.1(x64)), 

the error 'corrects' itself if you enter the new value a second time (then the
correct intermediate result is available, 

a very very vague guess ... could it possibly be that the task(s) - contrary to
the setting 'unthreaded' - is/are distributed over several tasks / threads /
cores, and that they - since they know nothing about their dependency -
independently come to the erroneous assumption to be done? 

In combination with 'not seeing the necessity of iterations regarding ignoring
the dependency of the results' could explain the phenomena observed on the
surface. 

sorry for my bad english ... deepl ...

b.

-- 
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/20191207/55b372fd/attachment.html>