https://bugs.documentfoundation.org/show_bug.cgi?id=129658
--- Comment #5 from hardcoder <[email protected]> --- (In reply to b. from comment #4) > but are narrowed towards a desired precision by those iterations. That is the LibreOffice assumption that those calculations are convergent. Actually they are simply cumulative, not always convergent. > somewhat similar to 'goal seek' and 'solver'? A bit more specific, I guess. AFAIK goal seek and solver are based on inverse problems; iteration doesn't try to invert anything for the user, so it has no specific root-finding or algebraic/symbolic manipulation algorithms. > types: converging - solveable, diverging - not solveable, undefined - more > than one solution, I should note that MS Excel never actually cared about that classification; it simply runs what the user has commanded. Except when the variation gets too low (this is not really implemented in Calc). > never been working correctly in calc? As far as I can tell, never. > steps: max roundtrips to perform, The number of steps is not consistently followed in Calc, especially when it hides the accumulated value behind "Err:523". For "converging" numbers the number of actual iterations run seems to be exactly 3 for the first time, and 2 on recalcs, instead of e.g. the default 100. This only changes if the number of iterations is set to just 1. > minimum change: treshhold to stop iterations once changes are below, border That is the original Excel behavior, that Calc DOESN'T follow. > to show 'errr:xxx' if changes are above limit when run out of iterations, Now that's Calc-specific, and prevents lots of uses of the feature (as I wrote in bug 136897). And iterations are still calculated underneath even when the only visible thing is Err:523. 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.
