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

Discuss the spreadsheet application

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

Postby Nemesis » Wed Jan 08, 2020 6:10 pm

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)
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
Nemesis
 
Posts: 12
Joined: Wed Jan 08, 2020 5:53 pm

Re: replace https address with images in link?

Postby Villeroy » Wed Jan 08, 2020 7:30 pm

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, no OpenOffice, LibreOffice 6.4
User avatar
Villeroy
Volunteer
 
Posts: 28641
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: replace https address with images in link?

Postby Nemesis » Wed Jan 08, 2020 9:00 pm

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
Nemesis
 
Posts: 12
Joined: Wed Jan 08, 2020 5:53 pm

Re: replace https address with images in link?

Postby Villeroy » Wed Jan 08, 2020 10:37 pm

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, no OpenOffice, LibreOffice 6.4
User avatar
Villeroy
Volunteer
 
Posts: 28641
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany


Return to Calc

Who is online

Users browsing this forum: fiona87, FJCC and 19 guests