Description: If you have added checkboxes to a calc sheet to summarize amounts that have been payed (if checked)and you copy the sheet to the next year (for example 2016 to 2017) the checkboxes in the 2017 sheet are still related to the 2016 sheet. This is an old problem that existed in earlier versions of LO too. Steps to Reproduce: 1.add a checkbox to a calc sheet 2.copy the sheet 3. Actual Results: the checkbox on the copied sheet is still connected with the original sheet Expected Results: should be connected to the same cell in the new sheet Reproducible: Always User Profile Reset: Yes OpenGL enabled: Yes Additional Info: [Information automatically included from LibreOffice] Locale: de Module: SpreadsheetDocument [Information guessed from browser] OS: Windows 10 pr OS is 64bit: yes
Created attachment 152247 [details] Testfile just copy a sheet copy a sheet in the file an you will find the described bug. The bug appears also if you copy the sheet to another file.
Confirmed with Ubuntu 18.04; Version: 6.0.7.3 Build ID: 1:6.0.7-0ubuntu0.18.04.6 CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: kde4; and Version: 6.4.0.0.alpha0+ Build ID: f75c2b04785aa05cff3bcd52689feb7400a14e8e CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: kde5; TinderBox: Linux-rpm_deb-x86_64@86-TDF, Branch:master, Time: 2019-06-15_11:49:26
IMHO this issue is a duplicate of Bug 121626 - When copying sheets or objects (checkboxes/charts) references in the objects are not updated *** This bug has been marked as a duplicate of bug 121626 ***