[Solved] Insert Image from Webpage

Discuss the spreadsheet application
Post Reply
osmosis
Posts: 23
Joined: Tue Jul 08, 2008 8:45 am

[Solved] Insert Image from Webpage

Post by osmosis »

Hi

Is it possible to insert an image into calc from a webpage?

In my case, the image is a graph that changes everyday.

I know how to use "Link to External Data" from the "Insert" menu, but this only inserts data, not images. Is there a similar way to insert an image that will refresh from the webpage everytime I open the .ods?

Thanks.
Last edited by osmosis on Tue Dec 30, 2008 3:04 am, edited 1 time in total.
OOo 3.0.X on MS Windows Vista
User avatar
Hagar Delest
Moderator
Posts: 32667
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: Insert Image from Webpage

Post by Hagar Delest »

Hi,

Try to select some text in addition with the pic and then delete the text. If the pic is not the only selection, the default paste setting in OOo is to link the target.

Thanks to add '[Solved]' at beginning of your first post title (edit button) if your issue has been fixed.
LibreOffice 7.6.2.1 on Xubuntu 23.10 and 7.6.4.1 portable on Windows 10
User avatar
acknak
Moderator
Posts: 22756
Joined: Mon Oct 08, 2007 1:25 am
Location: USA:NJ:E3

Re: Insert Image from Webpage

Post by acknak »

I don't think it's possible to have an automatically updated external image, but I don't know for sure. That feature is designed for data, not for general web content.
 Edit: PS: 
You can insert an image through a hyperlink to some file on the web. The image will be re-loaded when you load the spreadsheet, or if you update it manually through Edit > Links. I don't see any way to have it update automatically after some time interval.
AOO4/LO5 • Linux • Fedora 23
osmosis
Posts: 23
Joined: Tue Jul 08, 2008 8:45 am

Re: Insert Image from Webpage

Post by osmosis »

Thanks for the reply.

Do I try this using "Insert" -- "Hyperling" or "Insert" -- "Link to external data" ?

Thanks.
OOo 3.0.X on MS Windows Vista
User avatar
acknak
Moderator
Posts: 22756
Joined: Mon Oct 08, 2007 1:25 am
Location: USA:NJ:E3

Re: Insert Image from Webpage

Post by acknak »

Insert > Picture > From File. Paste the hyperlink in place of the file name. Make sure the "Link" option is selected.
AOO4/LO5 • Linux • Fedora 23
Post Reply