Ask Your Question

Is there a function in Calc to get the cell comments content? [closed]

asked 2015-07-30 19:15:30 +0200

Felipe Eckhard gravatar image

updated 2020-08-09 14:43:25 +0200

Alex Kemp gravatar image

Hi. I would like to know if there is some function in Calc that get the content of the comments of one specific cell.

I need this because I want to copy the comment content to another cell, but I need this content as a cell content, not as a comment content, ok?

For example, the cell B2 content's is "lion", and there is a comment in cell B2 that says "It's a kind of animal". I intend to copy the phrase "It´s a kind of animal" to cell C2.

Best regards.

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2020-08-09 14:43:46.420882

1 Answer

Sort by » oldest newest most voted

answered 2015-08-05 15:01:02 +0200

lolax gravatar image

Please check the URL and Lupp has provided a Link and there is a function CELL_NOTE should meet your requirement.

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2015-07-30 19:15:30 +0200

Seen: 1,928 times

Last updated: Aug 05 '15