https://bugs.documentfoundation.org/show_bug.cgi?id=46845
b. <newbie...@gmx.de> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |newbie...@gmx.de
--- Comment #7 from b. <newbie...@gmx.de> ---
yes, there is still something buggy ... funny ... odd ... strange ... curious
... weird ... with 'calc and iterations'. testing with the file submitted it's
clear:
- it has circular references (e.g. C5 depends on C30, C30 depends on C27, C27
depends on C5) and needs iterations to solve. the solveability and what result
is 'suspected' to be the correct result is difficult, sometimes undefined, and
depends heavily on start conditions.
(a very simple sample: A1:'10', B1:'=A1+10', C1:'=B1-10' will show | 10 | 20 |
10 |, what if you change A1 to '=C1'? i got as well | 10 | 20 | 10 | as | 0 |
10 | 0 | as results, and both are correct, even | 100 | 110 | 100 | is
correct, and you can provoke it by changing A1 from '100' to '=C1'.)
implementations in spreadsheets should try to come to a 'human acceptable'
solution?,
that's - in most cases - achieveable with the logic and default settings in
calc ,
but not in all.
on this sample and with ver. below i see three things 'funny':
- if you provoke an err. condition by switching iterations off and on again
calc produces heavily deviating results, (about 2.000.000 'off' in D37:G37
while C37 likes to stuck in err:523). hard recalc shows that better results
are! possible except for C37, that's trapped.
- the excel results in the provided pdf have no results in D35 and D37, the
'20.000.000 case', i hope that's a fault from excel.
- column C being trapped in the err: condition.
this quite old case shows what kohei yoshida wrote somewhere about recursions /
iterations in calc: 'old big problem, nothing to be fixed overnight',
behaviour independent from file format (xls or ods).
tested with ver.
Version: 6.4.0.1 (x64)
Build ID: 1b6477b31f0334bd8620a96f0aeeb449b587be9f
CPU threads: 8; OS: Windows 6.1 Service Pack 1 Build 7601; UI render: GL; VCL:
win;
Locale: de-DE (de_DE); UI-Language: en-US
Calc: CL
'unthreaded' and 'unCL' and 'un-both-of-them' have the same problems ...
--
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
