https://bugs.documentfoundation.org/show_bug.cgi?id=129658
--- Comment #4 from b. <[email protected]> ---
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.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
