In Libre Office Calc I have inserted an image into a worksheet, anchoring it to a cell. I then move to another worksheet and set a cell there to equal the contents of the image cell in the first sheet. I expected the image to show up in the cell in the second sheet, but instead get the value zero. How do I get this to work?
You can’t. A spreadsheet is not a database. Pictures are decoration or illustration but they are not data.
Well, shucks. That makes it more difficult for me. Thanks for your reply, Villeroy.
Creating a list (or many interrelated lists) with references to pictures and showing these pictures in forms and reports is something a spreadsheet can not do without heavy macro programming.
It is rather easy to do with a database. You can use any kind of database you are familiar with if it has an ODBC or JDBC driver.
LibreOffice can create HSQL databases and Firebird databases from scratch.
https://www.mediafire.com/file/bxmgmowupp0wsw1/PicsDB.zip/file contains some pictures, 3 database documents and a spreadsheet in the same folder.
BasePics_FB.odb contains a Firebird database, a form for input and a report for printable output. The database stores only the file names of the pictures. In the form, double-clicking a picture opens a file picker dialog.
BasePics_HSQL.odb contains a HSQL database with the same UI elements.
BasePics_Calc.odb demonstrates that it is even possible to create the same layouted report from spreadsheet data. The database document is linked to SheetPics.ods. This pseudo-database is not editable in Base but the report works in the same way. All documents are free of macro code.