Bug 130512 - Cloning a cell's format should also clone the format of the cell's comment
Summary: Cloning a cell's format should also clone the format of the cell's comment
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Hardware: All All
: medium enhancement
Assignee: Not Assigned
Depends on:
Blocks: Calc-Comments
  Show dependency treegraph
Reported: 2020-02-07 18:46 UTC by Richard
Modified: 2020-08-11 17:49 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description Richard 2020-02-07 18:46:35 UTC
Clone Formatting of a cell should clone, not just the cell's formatting, but also its Comment's.

My former .XLXS spreadsheet contains lots of comments, many of which have no fill and other problems. I don't want to edit the parameters individually for hundreds of comments.

MacOS Catalina 10.15.2
Comment 1 eisa01 2020-02-15 22:56:21 UTC
So yes, this is the case. The formatting of the comment is not copied

I guess we need an assessment whether this is wanted behavior or not from the UX group

LO behavior is currently identical to Excel, the comment format is not copied
Comment 2 Heiko Tietze 2020-02-27 14:21:53 UTC
We discussed the topic in the design meeting and agree with the request.
If the comment has a complex formatting like <red>ABC</red><blue>DEF</blue> it could simply take the format from the first letter (which is what MSO does).

Interestingly the copy format function works not on complex cell formatting, not only the comment.