[Libreoffice-bugs] [Bug 121002] Cells not recalculating after moving

[bugzilla-daemon at bugs.documentfoundation.org]

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

Peter Beurle <peter.beurle at bigpond.com.au> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
     Ever confirmed|0                           |1
             Status|RESOLVED                    |NEW
         Resolution|NOTABUG                     |---

--- Comment #8 from Peter Beurle <peter.beurle at bigpond.com.au> ---
Steps to reproduce;

1. Create a blank worksheet

2. Ensure AutoCalculate is turned on Data|Calculate. This should mean any
changes to cell values are recalculated automatically, without F9 manual
recalculation. 

3. Create a small table of four rows and three columns. In column C put a
formula SUM(A1:B1) and copy down to row four.

4. In A3 and B3 put in 3, C3 should now show 6

5. In A4 and B4 put in 4, C4 should now show 8

6. Select cells A3 to B4 and drag (move) to A1. A1 and B1 should now have 3 in
them and A2 and B2 should now have 4 in them.

7. Cell C1 shows zero. The formula in cell C1 is SUM(A1:B1). Expected result is
6

8. Cell C2 shows zero. The formula in cell C2 is SUM(A2:B2). Expected result is
6

9. Select cell C1 and push F9, result is 6 ∴ cells did not auto recalculate.

10. The relationship between the values and result on row three and four
changed on the move. The formula in C3 now represents the values in A1 and B1.
The formula in C1 has had its values change, effectively overwritten by the
move. If you do this in Excel formula in C1 and C2 return #REF!, indicating the
references have been broken. This warns the user that they have made changes to
the referenced cells A1:B2

-- 
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/20181121/9f51c9e5/attachment-0001.html>