Created attachment 168134 [details] Shows the duplicated Comments in Cells Hello, I noticed strange behavior in Calc. If you add comments to a worksheet and then set the comments to "show comment", the comments are duplicated when a copy of the worksheet is created. At first it is not noticeable because they were copied exactly congruent. You have to mark a comment and move it with the mouse so that it becomes clear. It is even stranger that suddenly there are two comments in one cell. I can top this: If you create another copy of the worksheet copy, there are three comments in the "comment cell". It doesn't matter whether you copy the worksheet with the mouse and [CTRL], or via the context menu "Register of worksheet" and then make a copy, e.g. in a new document. For me reproducible in: a) LibreOffice Version: 6.2.2.2 (portable) b) Version: 7.0.1.2 (x64) Build ID: 7cbcfc562f6eb6708b5ff7d7397325de9e764452 CPU threads: 4; OS: Windows 10.0 Build 19042; UI render: Skia/Raster; VCL: win Locale: de-DE (de_DE); UI: de-DE Calc: CL c) Version: 7.2.0.0.alpha0+ (x64) Build ID: 5abb1890ffafe5a2212076208a1c6e226f1ffa4e CPU threads: 4; OS: Windows 10.0 Build 19042; UI render: Skia/Raster; VCL: win Locale: de-DE (de_DE); UI: de-DE Calc: CL Reset Userprofils = YES OS = Win 10 Pro 20H2 I set the severity to "major" because I suspect that if you have a lot of comments, the system can slow down considerably if spreadsheets are copied in the manner described. Especially since it is not noticeable that the comments are congruent on top of each other. Best regards Juergen
Thank you for reporting the bug. Please attach a sample document, as this makes it easier for us to verify the bug. I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' once the requested document is provided. (Please note that the attachment will be public, remove any sensitive information before attaching it. See https://wiki.documentfoundation.org/QA/FAQ#How_can_I_eliminate_confidential_data_from_a_sample_document.3F for help on how to do so.)
Created attachment 168154 [details] further descriptions cell comments and copied sheet
Juergen Klatt: I noticed you assigned yourself, do you want to fix the code yourself or was it just a mistake?
Hello Julien Nabet, [quote]I noticed you assigned yourself, do you want to fix the code yourself or was it just a mistake? It is a mistake. I don't know what I've done wrong. [quote] do you want to fix the code yourself I'm unable to correct code.
I can confirm that the bug is present in master. after closing and reopening the file, everything is fine. Version: 7.2.0.0.alpha0+ (x64) Build ID: 59301a1cadd87a63276650975252d14e8477e632 CPU threads: 4; OS: Windows 10.0 Build 19042; UI render: Skia/Raster; VCL: win Locale: cs-CZ (cs_CZ); UI: en-US Calc: threaded Also in Version: 4.1.0.1 Build ID: 1b3956717a60d6ac35b133d7b0a0f5eb55e9155
Quick read how to reproduce: 1) Make comment of a cell 2) set it like shown 3) copy sheet
Also reproducible in LibreOffice 3.3.0 OOO330m19 (Build:6) tag libreoffice-3.3.0.4
Hi Dennis. Since you fixed bug 94561, I hope you could see this bug.
*** This bug has been marked as a duplicate of bug 108263 ***