My os is Xp . OpenOffice version 2.3.0
Trying to import the data from this website into Calc
http://biz.thestar.com.my/marketwatch/main.asp?clp=4
After pasting the above link, the OK button remain dim, nothing happened.
please help ?
How to import external data from website to Calc?
- Hagar Delest
- Moderator
- Posts: 32667
- Joined: Sun Oct 07, 2007 9:07 pm
- Location: France
Re: How to import external data from website to Calc?
Could you please detail what you're trying to do exactly ? There is nothing at the end of your link (the site returns "Sorry, No Data Available").
Do you want to copy & paste some data ?
Do you want to copy & paste some data ?
LibreOffice 7.6.2.1 on Xubuntu 23.10 and 7.6.4.1 portable on Windows 10
Re: How to import external data from website to Calc?
Often in OpenOffice, filling an input dialogue line with paste is not detected. I usually add a space to the end of what I pasted, and then delete it again. The OK button becomes active as soon as I hit the space bar.
Re: How to import external data from website to Calc?
I could open the URL in Firefox, select the table and paste it into a blank sheet, and this worked fine, since paste understands html data. What this doesn't do is to give you an "Import from Web page" function based on a given URL. The URL is invalid for doing an Insert -> Link to External Data. That's the functionality, I'm sorry to say. It doesn't work in Excel either
Ubuntu 11.04-x64 + LibreOffice 3 and MS free except the boss's Notebook which runs XP + OOo 3.3.
- Hagar Delest
- Moderator
- Posts: 32667
- Joined: Sun Oct 07, 2007 9:07 pm
- Location: France
Re: How to import external data from website to Calc?
+1.TerryE wrote:I could open the URL in Firefox, select the table and paste it into a blank sheet, and this worked fine, since paste understands html data.
Don't know why the site was not available before.
LibreOffice 7.6.2.1 on Xubuntu 23.10 and 7.6.4.1 portable on Windows 10