https://bugs.documentfoundation.org/show_bug.cgi?id=136897
--- Comment #9 from hardcoder <[email protected]> --- I discovered a trick to observe string iteration. If the string's length varies, you won't be able to see it, because any string size change under iteration triggers Err:523 (even if the string shrinks). But if you interleave rest states into the string calculation, you can see the string (half of the time): 1. Create a new spreadsheet in Calc. 2. Make sure iteration is enabled in Options. 3. On A1, enter: =MOD(A1+1,4) This will make the value of A1 swap between 1 and 3 on recalcs (unless the number of iteration steps is 1). 4. On A2, enter: =IF($A$1=1, A2, A2&"a") 5. Optional: on A3 enter: =LEN(A2) 6. Press Ctrl+Shift+F9 a number of times. If you just press F9, only the selected cell among the iterative ones will be updated, which is yet another incompatibility with Excel, but who's caring. >From here, the result is that A2 alternates between Err:523 and 0aaaaaa... -- You are receiving this mail because: You are the assignee for the bug.
