https://bugs.documentfoundation.org/show_bug.cgi?id=124577
--- Comment #6 from b. <newbie...@gmx.de> ---
Created attachment 156818
--> https://bugs.documentfoundation.org/attachment.cgi?id=156818&action=edit
shrinked sheet with the error still occuring
looks like one more of my well beloved 'shared formula breaks autocalculate' or
'neglected dependencies' or 'threaded still experimental' problems.
starts with cell H5 being calculated to 21 instead of 30 on drag or copy from
row 4 to row 5.
fails with 'threaded' or 'CL' enabled on my system, works better with both off,
minimum reproducer as of now:
attached sheet piraci_test2.ods (stripped some rows and columns), copy B4:H4 to
B5:H5, value in H5 (21) wrong against formula (=B5+11) == (19+11) == (30),
as shift-ctrl-F9 helps out ... standard 'autocalculate broken with shared
formulae'?
assumption: calculation of H5 is done without taking into account that the
value of B5 - copied from B4 as value: "10", formula: "=D3", has to have the
relative reference in the formula adapted to "=D4" and thus will change it's
value too. 10 (value of copied B4) plus 11 (number to add for H5) will give the
21 shown in H5. things like this may occur when implementing non mature
parallelizing mechanisms ... :-(
(i admit that even in theory it is difficult to reconcile the splitting of a
task (for parallelized processing) and the keeping together of dependencies (to
recognize circular references and for proper 'clarification' of shared
formulas) ... big praise to the developers that some of it works at all! ...
looks as nobody is taking me serious ... imho it's time for a fix or kill-out
of the source of this minefield of bugs instead of plastering only the errors
which make it through to users notice ...
*** kiss *** keep it simple and stupid *** avoid use of exotic constructs and
functions *** and experimental features like parallellized computing *** and
you'll be happy and save time of your life *** but the training of your brain
is neglected *** that helps to stay happy too ***
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
