TOP

Image Function

IMAGE() Description

The IMAGE function in LibreOffice Calc allows users to insert images directly into spreadsheet cells using a URL.

This enhances data visualization by embedding relevant graphics, such as product photos, charts, or icons, alongside cell content. Users can also control the image size and alignment within the cell for a clearer and more customized layout.


Key Features of the IMAGE Function

Syntax:

=IMAGE(source, destination, [sizing], [height], [width])

Parameters:

If only one of the height/width arguments is specified, the image's aspect ratio will be preserved according to the provided argument.

Example of Use

Example 1

The IMAGE() function is easy to use. You just need to enter the URL path to the image and the cell where the image should be placed, and Excel (Calc) will automatically insert the required image:

=IMAGE(source; destination; sizing)

We will get the following result:

Example of using the IMAGE() function
Example of using the IMAGE() function

In this example, the following values are used:

Example 2

Example of using the IMAGE() function
Example of using the IMAGE() function

In this example, the following values are used:

For Excel, this function is named IMAGE2, to avoid conflicts with the built-in function IMAGE.

Download extension

You can use the function IMAGE() by installing the extension YLC Utilities.

After this, this function will be available in all files opened in Excel (LibreOffice Calc).


This function is also available in the following extensions: YLC FunctionsYLC Utilities

The YLC Utilities menu in LO Calc

The YLC Utilities menu in LO Calc

The YLC Utilities menu in Excel

The YLC Utilities menu in Excel