https://bugs.documentfoundation.org/show_bug.cgi?id=140866
PaulSh <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEEDINFO |UNCONFIRMED Ever confirmed|1 |0 --- Comment #10 from PaulSh <[email protected]> --- After literally YEARS of trying on and off to get a repro on this issue, I finally have one. OK, I guess I can't guarantee that my method of making comments disappear is the same as the OP's, but at least it's 100% reproducible. 1) Create an empty spreadsheet and add a comment to cell A1 2) Copy this cell through O1 so now there are 15 comments visible (I don't think the exact number is significant, it's just that I see columns A through O when I create a new sheet) 3) Copy the top row through row 40 so now there are 600 comments visible (again I don't think the exact number is significant, but doing this makes it very easy to see if a comment has gone missing) 4) In design mode, create a form control on the sheet in the uncommented region - I've tested with a button and a label 5) Save and close 6) Open the sheet - it should look fine 7) In design mode, select the control, copy it (ctrl+c), select a cell somewhere else in the uncommented region and paste (ctrl+v) 8) Save and close 9) Open the sheet - some comments will be missing! One other thing to note is that even when comments have gone missing from the saved file, in the open sheet itself the comments are still present in both the sheet annotations object AND the individual cell annotation fields. I will attach copies of the test sheet before and after the control was copied and pasted. Just for the sake of it, here's my Calc info, but really the issue has been there for a long, long time: Version: 7.1.5.2 (x64) / LibreOffice Community Build ID: 85f04e9f809797b8199d13c421bd8a2b025d52b5 CPU threads: 4; OS: Windows 10.0 Build 19044; UI render: default; VCL: win Locale: en-GB (en_GB); UI: en-GB Calc: CL -- You are receiving this mail because: You are the assignee for the bug.
