[Libreoffice-bugs] [Bug 142098] Calc: pasting comment clears cell contents

[bugzilla-daemon at bugs.documentfoundation.org]

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

Martin Wilck <mwilck at suse.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
     Ever confirmed|0                           |1
             Status|RESOLVED                    |REOPENED
         Resolution|NOTABUG                     |---

--- Comment #4 from Martin Wilck <mwilck at suse.com> ---
(Hi, I'm the person who reported this to Markéta on SUSE bugzilla).

I can see that it's documented to work this way. But it makes no sense to me.
Comments aren't cell contents. If nothing except "Comments" is activated below
"Selection", why would the user also have to choose "Add", too? The expectation
is that the comments and *only* the comments are pasted, otherwise the user
would have selected at least one of the other "Selection" options besides
"Comments", e.g. "Text" or "Numbers".

And if this really is how "paste special" should behave, why isn't it the case
for pasting "Formats"? In that case, users don't have to select "Add" to paste
the formats and nothing else. This is inconsistent at least.

Can you provide a rationale for this behavior?

Not sure if this matters, but Excel doesn't require selecting "Add": 

https://support.microsoft.com/en-us/office/insert-comments-and-notes-in-excel-bdcc9f5d-38e2-45b4-9a92-0b2b5c7bf6f8#ID0EBACAAA=Windows
https://www.extendoffice.com/documents/excel/1258-excel-copy-comments-from-cell-to-another.html

(I can't test with Excel, because the only version I have is Excel/Web in o365,
which doesn't have general "Paste special" functionality at all; same for
Google Docs).

The screenshot in the 2nd reference above suggests that, in Excel, the
"Operation" selection is actually inactive / greyed out when "Comments" are
selected only.

I found another equally weird and possibly related issue: When pasting "Text"
only into a cell which has a comment, the comment of the target cell (the one
pasted into) is deleted. This is highly unexpected, at least by yours truly.
Selecting "Add" doesn't change this behavior. Actually, I haven't figured out
how to paste anything into a cell in LO 7.2 without destroying the existing
comments on that cell (well, pasting "Formats" only seems to work). This
definitely differs from the behavior of both Excel and Google Docs. 

If you think this is not a bug, please provide some convincing arguments.

-- 
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/20210505/e21910b7/attachment-0001.htm>