[Libreoffice-bugs] [Bug 138881] New: [CALC][Comments]When copying worksheets, cell comments are duplicated

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=138881

            Bug ID: 138881
           Summary: [CALC][Comments]When copying worksheets, cell comments
                    are duplicated
           Product: LibreOffice
           Version: 6.2.2.2 release
          Hardware: x86-64 (AMD64)
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: jrk33 at web.de

Created attachment 168134
  --> https://bugs.documentfoundation.org/attachment.cgi?id=168134&action=edit
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

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20201213/2fe67f1d/attachment.htm>