External Links Not Working

English
#1

Hi everybody.

I am trying to import external links but it is not working anymore.
This is an example of a link I am trying to retrieve https://www.investing.com/equities/gulf-keystone-petroleum-ratios

Any way I can import?

Is there a way to import a specific number from a table in the link same as I did with google sheets (=IF(NOW(),Index(IMPORTHTML(“https://www.investing.com/equities/gulf-keystone-petroleum-ratios","table”,2),2,2))

I am on Debian Testing, KDE. Updated everything.

I will appreciate any help to enable me to retrieve external data.

Thank you in advance
(P.S. I tried to search the forum, but couldn’t find solution)

Version: 24.2.4.2 (X86_64) / LibreOffice Community
Build ID: 420(Build:2)
CPU threads: 8; OS: Linux 6.9; UI render: default; VCL: kf5 (cairo+wayland)
Locale: en-US (C.UTF-8); UI: en-US
Debian package version: 4:24.2.4-1+b2
Calc: threaded
#2

I’m pretty sure IMPORTHTML isn’t supported in LibreOffice (yet); but you can import data another way: Frequently asked questions - Calc - The Document Foundation Wiki

#3

Me too, this is a google sheet function.
I tried exactly what’s in the link but nothing happens. Nothing shown to select from!

#4

https://wiki.documentfoundation.org/Documentation/Calc_Functions/WEBSERVICE

https://help.libreoffice.org/latest/en-US/text/scalc/01/func_webservice.html

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.