Ask Your Question

Cannot delete comment dot from converted spreadsheet [closed]

asked 2016-08-26 18:03:45 +0100

inkswamp gravatar image

updated 2020-08-10 22:12:35 +0100

Alex Kemp gravatar image

A few months ago, I converted a spreadsheet from OpenOffice to LibreOffice. At the time, some cells had comments. I've since noticed that any cells that contained comments in the OpenOffice sheet can be deleted, but the little red indicator in the cell won't disappear. It works fine for any comments added and deleted now, but the cells where there were comments during the conversion will not go away.

Even if I do a "delete all" on the cell, the contents and formatting and everything else goes away but the red dot remains. Frustrating.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-08-02 13:13:44.753677

1 Answer

Sort by » oldest newest most voted

answered 2016-08-27 16:04:31 +0100

mark_t gravatar image

If you add and then delete a comment to one of these cells can you remove the red dot?

Also try creating a new sheet and copy everything from the old sheet.

If above is not working can you edit your question and attach example, use a copy with all data deleted to avoid publishing information.

edit flag offensive delete link more


I tried adding a new comment and removing it but the red dot persisted, however...

Your second suggestion of copying and pasting the entire thing into a new sheet did the trick! It carried over the comments I've added using LibreOffice but none of the errant dots. I didn't even think to do that because this spreadsheet is tied in with several other sheets in the same document but I'm happy to re-link the fields.

Thank you for the help.

inkswamp gravatar imageinkswamp ( 2016-08-29 04:04:41 +0100 )edit

Question Tools

1 follower


Asked: 2016-08-26 18:03:45 +0100

Seen: 432 times

Last updated: Aug 27 '16