Importing images to calc via fileref

I have spreadsheet where the first column A contains the file location of photo. Probably there will be 50-100. I want to use the file ref to import the image (thumbnail) into column B. I know I found a way to do that some time ago but not now. How can I put a command in col B to retrieve the image. Something like =lookup image (A2 etc). Alternatively run a command to replace the file ref with the actual image. (The extension that might do this has bugs.)