TOP

GetComment function

GETCOMMENT() Description

The function GETCOMMENT() is designed to get the comment of a cell.

You can also use a ready-made tool "Copy comment to cell" , which automatically copies the comment for the selected cells.


Main Features GETCOMMENT Functions

Syntax:

=GETCOMMENT(Cell)

Parameters:

Example Usage

The GETCOMMENT() function is easy to use. You just need to specify the cell with the comment and LO Calc will automatically return the text of her comment:

=GETCOMMENT(Cell)

We will have the following result:

GETCOMMENT formula usage

This example uses the following values:

Download extension

You can use the function GETCOMMENT() by installing the extension YLC Utilities .

After that, this function will be available in all files that are opened in LibreOffice Calc .