[Libreoffice-bugs] [Bug 129658] for bug hunting session: old recalc issue still problem

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #4 from b. <newbie-02 at gmx.de> ---
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 ...

-- 
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/20200518/251d1836/attachment.htm>