https://bugs.documentfoundation.org/show_bug.cgi?id=160092
Bug ID: 160092
Summary: Add IMAGE function for Calc formulas
Product: LibreOffice
Version: 3.3.0 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: m...@letorbi.com
Description:
Microsoft Excel and apparently also Google Docs support the IMAGE function in
formulas to load an image from an URL and insert it inside a cell.
=IMAGE(source, [alt_text], [sizing], [height], [width])
Further details can be found on [Microsoft's reference page for the IMAGE
function](https://support.microsoft.com/en-gb/office/image-function-7e112975-5e52-4f2a-b9da-1d913d51f5d5).
I recently stumbled about the missing IMAGE function in Calc, when I tried to
open a spreadsheet, which used the function to show dynamically generated
QR-Codes based on the content of a cell. Here is the formula:
=image("https://quickchart.io/qr?text="; & ENCODEURL(J4))
A quick research revealed that other persons had similar issues or at least
required a similar functionality, so there definitely seem to be use-cases
where such a function would be helpful:
*
https://ask.libreoffice.org/t/feature-request-insert-images-into-calc-cells/6822
*
https://ask.libreoffice.org/t/in-calc-is-there-a-way-to-set-the-source-of-an-image-using-a-formula/26652
* https://ask.libreoffice.org/t/macro-to-display-an-image-by-cell-value/75886
The latter two discussions also include examples for macros that resemble at
least parts of the required functionality, therefore I assume that the
implementation should be feasible.
A macro might be even an acceptable workaround for the time being, but in the
end it would be awesome, if Calc could provide a native IMAGE function. Not
only to offer Calc users a new feature to enhance their spreadsheets, but
primarily to allow correct handling of Excel and Google spreadsheets that use
this function.
Steps to Reproduce:
n/a
Actual Results:
n/a
Expected Results:
n/a
Reproducible: Always
User Profile Reset: No
Additional Info:
n/a
--
You are receiving this mail because:
You are the assignee for the bug.
