Description: 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:
+++1
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.
Has been mentioned a few times in the forum I believe, with some somewhat-desperate workaround attempts mentioned. E.g.: https://ask.libreoffice.org/t/feature-request-insert-images-into-calc-cells/6822/12 Someone has made an add-on, but I believe this walks the entire sheet rather than being used only as needed. https://extensions.libreoffice.org/en/extensions/show/links-to-images
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: https://insider.microsoft365.com/en-us/blog/insert-images-in-cells-with-the-image-function-in-excel
*** Bug 160092 has been marked as a duplicate of this bug. ***
Google Sheets: <https://support.google.com/docs/answer/3093333> Excel 365 / for the web / online and similar: <https://support.microsoft.com/en-us/office/image-function-7e112975-5e52-4f2a-b9da-1d913d51f5d5>
What's new in Office 2024 and Office LTSC 2024 ============================================== https://support.microsoft.com/office/what-s-new-in-office-2024-and-office-ltsc-2024-baadecbe-a8fc-4435-8cb8-70e93fd08b56 Text and array functions ------------------------ There are now 14 new text and array functions in Excel 2024 that are designed to help you manipulate text and arrays in your worksheets. These functions make it easier to extract and split text strings and enable you to combine, reshape, resize, and select arrays with ease. TextBefore() - TEXTBEFORE function Returns text that’s before delimiting characters https://support.microsoft.com/office/textbefore-function-d099c28a-dba8-448e-ac6c-f086d0fa1b29 TextAfter() - TEXTAFTER function Returns text that’s after delimiting characters https://support.microsoft.com/office/textafter-function-c8db2546-5b51-416a-9690-c7e6722e90b4 TextSplit() - TEXTSPLIT function Splits text into rows or columns using delimiters https://support.microsoft.com/office/textsplit-function-b1ca414e-4c21-4ca0-b1b7-bdecace8a6e7 VStack() - VSTACK function Stacks arrays vertically https://support.microsoft.com/office/vstack-function-a4b86897-be0f-48fc-adca-fcc10d795a9c HStack() - HSTACK function Stacks arrays horizontally https://support.microsoft.com/office/hstack-function-98c4ab76-10fe-4b4f-8d5f-af1c125fe8c2 ToRow() - TOROW function Returns the array as one row https://support.microsoft.com/office/torow-function-b90d0964-a7d9-44b7-816b-ffa5c2fe2289 ToCol() - TOCOL function Returns the array as one column https://support.microsoft.com/office/tocol-function-22839d9b-0b55-4fc1-b4e6-2761f8f122ed WrapRows() - WRAPROWS function Wraps a row array into a 2D array https://support.microsoft.com/office/wraprows-function-796825f3-975a-4cee-9c84-1bbddf60ade0 WrapCols() - WRAPCOLS function Wraps a column array into a 2D array https://support.microsoft.com/office/wrapcols-function-d038b05a-57b7-4ee0-be94-ded0792511e2 Take() - TAKE function Returns rows or columns from array start or end https://support.microsoft.com/office/take-function-25382ff1-5da1-4f78-ab43-f33bd2e4e003 Drop() - DROP function Drops rows or columns from array start or end https://support.microsoft.com/office/drop-function-1cb4e151-9e17-4838-abe5-9ba48d8c6a34 ChooseRows() - CHOOSEROWS function Returns the specified rows from an array https://support.microsoft.com/office/chooserows-function-51ace882-9bab-4a44-9625-7274ef7507a3 ChooseCols() - CHOOSECOLS function Returns the specified columns from an array https://support.microsoft.com/office/choosecols-function-bf117976-2722-4466-9b9a-1c01ed9aebff Expand() - EXPAND function Expands an array to the specified dimensions https://support.microsoft.com/office/expand-function-7433fba5-4ad1-41da-a904-d5d95808bc38 New IMAGE function ------------------ Now in Excel 2024, you can add pictures to your workbooks using copy and paste or you can use the IMAGE function to pull pictures from the web. You can also easily move, resize, sort, and filter within an Excel table without the image moving around. Image() - IMAGE function https://support.microsoft.com/office/image-function-7e112975-5e52-4f2a-b9da-1d913d51f5d5
The Document Foundation blog entitled “Lox365 extension: XLOOKUP (and more) for LibreOffice Calc” https://blog.documentfoundation.org/blog/2022/09/23/lox365-extension-xlookup-and-more-for-libreoffice-calc/ GitHub repository “Lox365: XLOOKUP for LibreOffice” https://github.com/goosepirate/lox365?tab=readme-ov-file#image Perhaps this can help with implementing the IMAGE function? Thank you