Convert formula to text

Formula > Convert formula into text

This tool converts a cell formula into its text value.

This way, you can copy the formula to other cells without automatically shifting the columns and rows.

Screenshot

Before conversion:

After conversion:

Running this tool

Click YLC Utilities > Formula > Convert formula into text :

How much time will this save?

Using this tool will definitely save you time and effort. However, the actual time savings will depend on how often you use it. LO Calc , the amount of data you work with, and how often you use this tool.

Download extension

You can use the utility Convert formula into text by installing the extension YLC Utilities .

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