Linking a photo to a calc sheet automatically based on the name in a cell

[ummita]

so I am not sure if this is possible

I made a simple sheet with 3 columns:
column A is called “Location”
column B is called “name of photo”
and column C is called “photo”

Then I have a folder that has photos of several locations, the names of these photos are entered in calc in column B.
For example, Location would be Sequim (which is by the way a small city in WA state) and the photo is called lavender (for their yearly lavender festival).

The way to usually add a photo is to go to each cell in column C, click on insert image and find the image in the folder, click “link”, click “anchor to cell (resize with cell)” and then after it is added, right click the image and select “fit to cell”.

Since I have all the names of the photos already added in column B, would it be possible to write a command that would do add the photo based on the name in column B automatically?

I am using the latest version of calc 7.4, with windows 10.

[Zizi64]

It is not the best idea to store the photos in a Calc document.

A tip:
Link them only by Hyperlinks, and the default image viewer will open and show them - when you clibk on the link. Use Relative hyperlinks, then it will works what you move all of the file onto another place.