[Libreoffice-bugs] [Bug 124270] error 522 on copying of rows in dev-6.3.0.0.alpha0-2019-03-22 editing

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=124270

--- Comment #5 from b. <newbie-02 at gmx.de> ---
two other procedures to show a bug in above version / file: 

A: mousedrag: 

1. with file and prog ver. from comment 4, 

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 comment 4, 

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 tdf#123714 and tdf#123736
had been, and the fixing done there, should be re-checked, 

reg. 

b.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190323/644af30e/attachment-0001.html>