<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_NEEDINFO " title="NEEDINFO - error 522 on copying of rows in dev-6.3.0.0.alpha0-2019-03-22 editing" href="https://bugs.documentfoundation.org/show_bug.cgi?id=124270#c5">Comment # 5</a> on <a class="bz_bug_link bz_status_NEEDINFO " title="NEEDINFO - error 522 on copying of rows in dev-6.3.0.0.alpha0-2019-03-22 editing" href="https://bugs.documentfoundation.org/show_bug.cgi?id=124270">bug 124270</a> from <a class="email" href="mailto:newbie-02@gmx.de" title="b. <newbie-02@gmx.de>"> b.</a> <pre>two other procedures to show a bug in above version / file: A: mousedrag: 1. with file and prog ver. from <a href="show_bug.cgi?id=124270#c4">comment 4</a>, 2. delete - the content!, not the rows - everything below row 1, 3. mark / select range A1:G1, 4. 'expand' it with the mouse for some rows below, 5. observe getting correct results for 1 to 50 rows (most times), 6. observe getting err:522 when pulling 100 rows or more (almost ever), 7. think that there's something wrong, - assumption: 'recursion' of autocalculate for 'shared formula groups' with dependent / referenced cells (ranges) is still broken or 'limited', 8. observe that forced recalc (strg-shift-F9) corrects the problem, 9. fault seems dependent on some complexity of the formulas and dependencies, boiling down to simpler constructions gave correct calculations - as far as i tested - B: copy-paste 1. with file and prog ver. from <a href="show_bug.cgi?id=124270#c4">comment 4</a>, 2. delete - the content!, not the rows - everything below row 1, 3. mark / select range A1:G1, 4. copy withe ctrl-c, 5. mark range A2:A100, 6. paste there with 'ctrl-v', 7. observe correct results, 8. mark cell C2 and cut with 'ctrl-x', 9. observe err:522 in cells C3 to C99, while formula in C99 references only correctly calculated and shown cells, 10. think that there's something wrong, - assumption: 'shared formula groups' are in the game as the error affects cells which are not! connected to the 'cut', besides they are copies into the same group ... 11. observe that forced recalc (strg-shift-F9) corrects the problem, 12. be aware that the need of forced recalc is almost ever a signal for something around autocalculate being broken, - assumption: the code area where the faults for bugs <a class="bz_bug_link bz_status_RESOLVED bz_closed" title="RESOLVED FIXED - Moving (Cut&Paste, Drag&Drop) a column range within the same row into a shared formula group's reference may not recalculate the first affected formula cell (procedure in comment 11)." href="show_bug.cgi?id=123714">tdf#123714</a> and <a class="bz_bug_link bz_status_RESOLVED bz_closed" title="RESOLVED FIXED - Changing a reference in a formula cell of a shared formula group may not rebuild all dependencies of the then split group." href="show_bug.cgi?id=123736">tdf#123736</a> had been, and the fixing done there, should be re-checked, reg. b.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>