[Libreoffice-bugs] [Bug 100475] :calculation error

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #11 from b. <newbie-02 at gmx.de> ---
more problem(s) left ... 

with low values in E7 (definitively not the purpose of the sheet and not 'real
life'; but a nice test to check the correctness of formulas and systematic
inside calc) you get 0 as result in B74 and H79 for ~100.000 to ~540.000 in E7,
below 100.000 B74 and H79 dont get final results, the iteration stops after two
circles despite changes above the  'minimum change' limit, and it takes up to
10 manual triggered recalculations (strg-shift-F9) until B74 and H79 reach
stable values. 

it's an effect of 'lagging behind' as described in other iteration bugs, e.g.
'bend_allowance' #81757 or 'silent, deceptive fail' #129199. 

it's easier to see when you format B74 and H79 to show more decimal places.

-- 
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/20200306/242bac36/attachment.htm>