https://bugs.documentfoundation.org/show_bug.cgi?id=136897
--- Comment #13 from hardcoder <[email protected]> --- (In reply to LizaVersy from comment #12) > Thanks for reporting this issue. > A new major release of LibreOffice is available since this bug was reported. > Could you please try to reproduce it with the latest version of LibreOffice > from https://litaviser.com/ > I have set the bug's status to 'NEEDINFO'. Please change it back to > 'UNCONFIRMED' if the bug is still present in the latest version. litaviser.com? I visited the site, and looks like an empty landing site offering itself for sale (possibly expired). I have LO 24.2.0.2 on my Win11 laptop, downloaded from https://downloadarchive.documentfoundation.org/libreoffice/old/ . Short answer: nothing changed, except for a subtle behavior regarding iterated strings (see below). Revising bug claims: > - Err:523 hiding the results (anti-feature). Still there, whenever Calc judges the variation is too large, a simple but limiting "convergence" check that MS Excel and other software don't have. > - 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. When doing iterated string concatenation, now sometimes Err:523 sticks and hides the result even when the added string is blank and the accumulated string isn't growing anymore (worse than before). But if you go to Options dialog and change the "Minimum change" field to whatever else, Err:523 is a string cell gets inhibited in case the value is not changing (head-scratcher). > - For numbers, the number of iterations is 3 at the first time, then 2 > (except if the number of iterations is set to 1). Still there, apparently like before. > - 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). Still there, apparently like before. > - 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.) Still there. You can confirm that with: A1: 0 A2: =A2+A1 A3: =A3+A2 Always take note of the value of A3 before recalc'ing. Then change A1 to 1; A2 will change a repeated number of times, all BEFORE updating A3 with intermediate values of A2. Only later, A3 is updated based on the last value of A2. MS Excel has a different behaviour, like I said. > Even another cell referencing the value (e.g. =A2) also splashes Err:523. Still there, apparently like before. Also: In Calc, iterative cells are kind of "non-volatile"; if you simply throw a recalc, they are not updated unless selected. If you do a "recalc hard", they are all updated. (Same behaviour as before.) Version: 24.2.0.2 (X86_64) / LibreOffice Community Build ID: b1fd3a6f0759c6f806568e15c957f97194bbec8f CPU threads: 8; OS: Windows 10.0 Build 22621; UI render: Skia/Raster; VCL: win Locale: en-US (C); UI: en-US Calc: threaded -- You are receiving this mail because: You are the assignee for the bug.
