<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_NEW " title="NEW - :calculation error" href="https://bugs.documentfoundation.org/show_bug.cgi?id=100475#c11">Comment # 11</a> on <a class="bz_bug_link bz_status_NEW " title="NEW - :calculation error" href="https://bugs.documentfoundation.org/show_bug.cgi?id=100475">bug 100475</a> from <a class="email" href="mailto:newbie-02@gmx.de" title="b. <newbie-02@gmx.de>"> b.</a> <pre>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.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>