https://bugs.documentfoundation.org/show_bug.cgi?id=136897
--- Comment #11 from hardcoder <he...@live.co.uk> --- I just downloaded and installed LO 7.3.1.3 from https://downloadarchive.documentfoundation.org/libreoffice/old/latest/win/x86_64/ and checked the iteration bugs, and it all seems the same. Bugs include: - Err:523 hiding the results (anti-feature). - For strings, Err:523 when it grows or shrinks in length, only not when the length doesn't vary. String content seems to be irrelevant in this aspect. - For numbers, the number of iterations is 3 at the first time, then 2 (except if the number of iterations is set to 1). - When the formula is NOT converging, the correct number of iterations (set in Options) is applied (this can't be directly seen; only when the value is not changing anymore). - All the iteration steps are calculated at a time for a cell, then for other cell, and so on (incompatible behavior). In MS Excel, an iteration is calculated for all cells (apparently even those in other workbooks, as long as they are open), then another iteration, etc. (The Excel behavior is more useful IMHO.) Also, I wrote some comments in bug 129658. 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.
