Bug 130512

Summary:	Cloning a cell's format should also clone the format of the cell's comment
Product:	LibreOffice	Reporter:	Richard <richardjaffe>
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	NEW ---
Severity:	enhancement	CC:	eisa01, heiko.tietze
Priority:	medium
Version:	unspecified
Hardware:	All
OS:	All
See Also:	https://bugs.documentfoundation.org/show_bug.cgi?id=99936
Whiteboard:
Crash report or crash signature:		Regression By:
Bug Depends on:
Bug Blocks:	101216

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.