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.
To copy:
After copying:
Click
Just use the following tool in the LO Calc menu:
This is much faster than manually copying each cell's comment into its formula.
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.
If you don't already have YLC Utilities, you can download the free version "YouLibreCalc.oxt" or the full-featured version "YLC_Utilities.oxt" .