<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_RESOLVED bz_closed" title="RESOLVED DUPLICATE - for bug hunting session: old recalc issue still problem" href="https://bugs.documentfoundation.org/show_bug.cgi?id=129658#c4">Comment # 4</a> on <a class="bz_bug_link bz_status_RESOLVED bz_closed" title="RESOLVED DUPLICATE - for bug hunting session: old recalc issue still problem" href="https://bugs.documentfoundation.org/show_bug.cgi?id=129658">bug 129658</a> from <a class="email" href="mailto:newbie-02@gmx.de" title="b. <newbie-02@gmx.de>"> b.</a> <pre>hi @Telesto, a real minefield there, sure you want to step in? iterations: repeated cycling through loops of 'cycling dependent' formulas which - regarding that dependecies - cant be calculated 'straight forward', but are narrowed towards a desired precision by those iterations. used for complex dependencies (plenty roundtrips, high precision), and by some people also as counter / running total / piggy bank (one roundtrip, low precision), somewhat similar to 'goal seek' and 'solver'? types: converging - solveable, diverging - not solveable, undefined - more than one solution, never been working correctly in calc? switch on: <tools - options - libreoffice calc - calculate - iterations> steps: max roundtrips to perform, minimum change: treshhold to stop iterations once changes are below, border to show 'errr:xxx' if changes are above limit when run out of iterations, one can either try with more iterations, or restart iterating (F9 or ctrl-shift-F9?), first results will be kept and if precision is reached after more attempts results are shown, critical: start values, imho calc tries often with '0' instead what's in the cells when you enable iterations, critical: where in the circle to start the loop, critical: what to do with nested loops, nice to start: 46850, replace top row by '1's, place focus inside formula range, and repeatedly hit F9, do often enough to see '1's converging towards the center, have fun ...</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>