TOP

Copy the comment to the cell

Comment > Copy comment to cell

This tool copies a cell comment into its formula.

In this way, you can, for example, restore a saved formula or an old cell value.

You can also use the function GETCOMMENT() , which returns the comment text of the selected cell.


Screenshot

To copy:

Comment > Copy comment to cell

After copying:

Comment > Copy comment to cell

Launch this tool

Click YLC Utilities > Comment > Copy comment to cell :

Comment › Copy the comment to the cell

Quick solution

Just use the following tool in the LO Calc menu:

YLC Utilities » Comment » Copy comment to cell

This is much faster than manually copying each cell's comment into its formula.

How much time will it save?

Using this tool, you are guaranteed to save time and effort. However, the actual time savings depends on how often you use LibreOffice Calc, the amount of data you work with, and how often you use the tool.

Download

If you don't already have YLC Utilities, you can download the free version "YouLibreCalc.oxt" or the full-featured version "YLC_Utilities.oxt" .


Additional keywords for this tool:
transfer comments to cell values, comments, formulas, annotations, comment box, edit comment, copy comment to cell, copy formula