GetComment function for LibreOffice Calc

GETCOMMENT() Description

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

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

Main Features of the GETCOMMENT function

Syntax:

=GETCOMMENT(Cell)

Parameters:

• Cell: The cell from which you want to get the comment.

Example Usage

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

=GETCOMMENT(Cell)

We will have the following result:

This example uses the following values:

• Cell: D4 - The cell from which you want to get the comment ("Engaging again with a different product. Get the client material ready.") .

Download the extension

You can use the GETCOMMENT() function by installing the free extension YouLibreCalc.oxt or its full-featured version YLC_Utilities.oxt .

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