Remove outer function

Power Query > Remove outer function

This tool allows you to automatically remove the outer (wrapper) function from all formulas in the selected column of LibreOffice Calc. This is ideal for debugging, simplifying, or preparing complex formulas for further processing.

The tool leaves only the inner arguments of the outer function, converting them into a new formula or value.

Screenshot

After applying:

Launching this tool

Click YLC Utilities > Power Query > Remove outer function :

LibreOffice Calc:

How much time will this save?

By using this tool, you are guaranteed to save time and effort. However, the actual time savings depend on how often you use LO Calc, the volume of data you work with, and how often you use this tool.

Download extension

You can use the utility Remove outer function by installing the extension YLC Utilities.

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