[Solved] (fairly) Replace https address with images in link?

[MrProgrammer]

I've imported a csv file, where the first cell row (A1,A2...) contains a weblink to a png (at least I think so)

Code: Select all   Expand viewCollapse view

https://image.api.np.km.playstation.net/images/?format=png&image=http%3A%2F%2Fapollo.dl.playstation.net%2Fcdn%2FEP0001%2FNPEJ00180_00%2FQ1QiP9fMLdvgX1wjdG8XjBWQZj9vK7G6.png&sign=9c03df804e6809e373062c6a43a7e3181d13a988


Is there anyway to get the calc to automatically load the images instead of the address in the cells?
it's around 700 of them, or do I need to download them manually and insert them as "normal" images? (don't want to do that)

[Villeroy]

You may feed the list of URLs to a computer program which can download stuff. This has nothing to do with spreadsheets. Calc can do almost nothing with pictures, even after you downloaded them.

[Nemesis]

Still have to insert them manually, wait, maybe if I export it as HTML (if that's possible), and use the replace function (which I hope exist), to add the image tag, then it should be displayed as images in the browser..

[Villeroy]

Indeed, a browser is one of those tools to download and display stuff. And HTML is much closer to your needs than any file format for arithmetic calculators such as Calc.