https://bugs.documentfoundation.org/show_bug.cgi?id=129658
--- Comment #6 from hardcoder <[email protected]> --- (In reply to b. from comment #4) > 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, If the cell has its formula changed somewhat, the starting point is 0 (even if it's a string iterated calculation) (which is consistent with MS Excel). If you do Recalc or Recalc hard, the value is not reset, thankfully (also consistent with Excel). > critical: where in the circle to start the loop, MS Excel seems to have a well-defined behavior about that, so it's interesting to consider following it. Usually cell evaluation order is based on a dependency graph/tree, but cells that are directly or indirectly dependent on iterative calculation are calculated in an simpler position-based order. You can check that by putting a simple iterated formula somewhere (e.g. on E7: =E7+1), and then simple references (=E7) around it in both sides. First, those formulas are sorted according to their sheet's name (I mean the end-user-defined name used in formula references, not the hidden VBA name); rename the sheets and watch the difference. Then they are sorted by row, and last by column. E.g. when referencing E7, the value in F6 or D7 is one iteration behind E7's value, but in F7 or D8, it's the same value as E7. As of LO 7.3.1.3 Calc, the behavior is different, apparently relying on a dependency tree even for iteration-dependent values. A more complex experiment would use two circularly dependent cells (e.g. E7: =H7+1; H7: =E7+1). Here again, Excel uses the sorting I just mentioned, so H7 is 1 unit more than E7. In LO Calc the opposite effect seems to occur. > critical: what to do with nested loops, What do you mean? Version: 7.3.1.3 (x64) / LibreOffice Community Build ID: a69ca51ded25f3eefd52d7bf9a5fad8c90b87951 CPU threads: 4; OS: Windows 10.0 Build 19044; UI render: Skia/Raster; VCL: win Locale: en-US (en_US); UI: en-US Calc: threaded -- You are receiving this mail because: You are the assignee for the bug.
