Bug 138881 - [CALC][Comments]When copying worksheets, cell comments are duplicated
Summary: [CALC][Comments]When copying worksheets, cell comments are duplicated
Status: RESOLVED DUPLICATE of bug 108263
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: medium minor
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Calc-Comments
  Show dependency treegraph
 
Reported: 2020-12-13 21:00 UTC by Juergen Klatt
Modified: 2023-06-20 07:06 UTC (History)
6 users (show)

See Also:
Crash report or crash signature:


Attachments
Shows the duplicated Comments in Cells (36.22 KB, image/jpeg)
2020-12-13 21:00 UTC, Juergen Klatt
Details
further descriptions cell comments and copied sheet (35.98 KB, application/vnd.oasis.opendocument.spreadsheet)
2020-12-14 15:21 UTC, Juergen Klatt
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Juergen Klatt 2020-12-13 21:00:36 UTC
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
Comment 1 Xisco Faulí 2020-12-14 10:31:44 UTC Comment hidden (obsolete)
Comment 2 Juergen Klatt 2020-12-14 15:21:11 UTC
Created attachment 168154 [details]
further descriptions cell comments and copied sheet
Comment 3 Julien Nabet 2020-12-14 19:27:30 UTC Comment hidden (obsolete)
Comment 4 Juergen Klatt 2020-12-14 19:37:08 UTC Comment hidden (obsolete)
Comment 5 Martin Srdoš 2020-12-17 17:21:04 UTC
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
Comment 6 Martin Srdoš 2020-12-17 17:22:39 UTC
Quick read how to reproduce:
1) Make comment of a cell
2) set it like shown
3) copy sheet
Comment 7 Martin Srdoš 2020-12-27 10:21:48 UTC
Also reproducible in
LibreOffice 3.3.0 
OOO330m19 (Build:6)
tag libreoffice-3.3.0.4
Comment 8 Timur 2021-07-15 10:44:50 UTC
Hi Dennis. Since you fixed bug 94561, I hope you could see this bug.
Comment 9 Buovjaga 2023-06-20 07:06:54 UTC

*** This bug has been marked as a duplicate of bug 108263 ***