https://bugs.documentfoundation.org/show_bug.cgi?id=90132
A (Andy) <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|UNCONFIRMED |NEW CC| |[email protected] Ever confirmed|0 |1 --- Comment #2 from A (Andy) <[email protected]> --- @Bug Reporter: Please correct if I explained/translated it not correctly. Reproducible with LO 4.4.1.2, Win 8.1. Problem: Some values are not updated if they are linked to another sheet and if the base value there is deleted. This does not happen if they are linked within the same sheet. It only happens if they are linked to another sheet. Steps to Reproduce: 1. Open CALC 2. In Sheet 1 write in the cells A1 to A15 the numbers 1 to 15. 3. Insert a second sheet. In this Sheet 2 link the cells A1 to A15 to the corresponding cells in Sheet 1 (-> "=Sheet1.A1" to "=Sheet1.A15"). 4. Go to Sheet 1 and delete the numbers in cell A1 and A3. 5. Now go to Sheet 2 Result: In Sheet 2 you have 0 in cell A1, but still 3 in cell A3, although the 3 in cell A3 in Sheet 1 was deleted (-> Bug). 6. In Sheet 1 select for instance cell A16 and A17 and copy them (Note: they are empty) to the cells A12:A13 (overwrite the entries). 7. Go to Sheet 2. Result: The cells A12 and A13 are updated correctly. 8. Save the file and reopen it. Result: Now everything is fine (updated) in Sheet 2 and cell A3 also shows 0. Alternatively, you can also open the attached file and delete there in Sheet 1 (Feuille1) the entries in cell A1 and A3. -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
