Bug 129129 - Add IMAGE Function to Calc
Summary: Add IMAGE Function to Calc
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Hardware: All All
: medium enhancement
Assignee: Not Assigned
: 160092 (view as bug list)
Depends on:
Blocks: Calc-Function Excel-Functions
  Show dependency treegraph
Reported: 2019-12-01 13:32 UTC by raal
Modified: 2024-05-18 09:44 UTC (History)
8 users (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description raal 2019-12-01 13:32:50 UTC
google sheets has IMAGE function, see https://sheetshelp.com/image/
Looks like useful function  -  asked https://ask.libreoffice.org/en/question/111949/in-calc-is-there-a-way-to-set-the-source-of-an-image-using-a-formula/ and https://ask.libreoffice.org/cs-cz/question/219345/calc-obrazek-z-hypertextu-braneho-z-policka/

Actual Results:

Expected Results:

Reproducible: Always

User Profile Reset: No

Additional Info:
Comment 1 m_a_riosv 2019-12-01 23:22:07 UTC
Comment 2 Vossman 2022-11-01 00:43:38 UTC
I just discovered this feature in Google Sheets this week, and it is awesome. Especially since LibreOffice does not do a good job of embedded image anchoring.

I really want this feature now.
Comment 3 stellarpower 2023-05-07 12:37:33 UTC
Has been mentioned a few times in the forum I believe, with some somewhat-desperate workaround attempts mentioned. E.g.:


Someone has made an add-on, but I believe this walks the entire sheet rather than being used only as needed.

Comment 4 Gerry 2024-02-19 10:39:36 UTC
In December 2022, MS Excel 365 added the IMAGE function, too.

The changelog describes the function as: "Insert in-cell images with the new IMAGE function: Your images can now be part of the worksheet, instead of floating on top. You can move and resize cells, sort and filter, and work with images within an Excel table."

See for details:
Comment 5 m_a_riosv 2024-03-08 03:22:15 UTC
*** Bug 160092 has been marked as a duplicate of this bug. ***