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

Discuss the spreadsheet application
Post Reply
Nemesis
Posts: 19
Joined: Wed Jan 08, 2020 5:53 pm

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

Post by Nemesis »

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

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)
Last edited by MrProgrammer on Thu Jan 09, 2020 12:03 am, edited 2 times in total.
Reason: Adjusted [Solved] in title
Openoffice 4.1.6 on Windows 10
User avatar
Villeroy
Volunteer
Posts: 31345
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: replace https address with images in link?

Post by 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.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Nemesis
Posts: 19
Joined: Wed Jan 08, 2020 5:53 pm

Re: replace https address with images in link?

Post by 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..
Openoffice 4.1.6 on Windows 10
User avatar
Villeroy
Volunteer
Posts: 31345
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: replace https address with images in link?

Post by 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.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Post Reply