Ask Your Question
1

How to use WEBSERVICE with LibreOffice 6.0.1.1 [closed]

asked 2018-02-12 20:13:45 +0200

albatros gravatar image

Dear all,

After the security update on WEBSERVICE, I'm not able to use the function anymore in Calc, as I used to. Even if I put a valid URL as an argument, I still get a #VALUE error.

What is now the correct way to use it? Are there any restriction on the URL beside the scheme (http or https), for instance to pass value into the URL as GET parameters?

Thanks for the insights,

Regards,

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by albatros
close date 2018-02-13 23:11:44.293777

1 Answer

Sort by » oldest newest most voted
0

answered 2018-02-12 23:06:00 +0200

m.a.riosv gravatar image

=MID(WEBSERVICE("http://tycho.usno.navy.mil/timer.html");166;21)
Works for me with
Version: 6.0.1.1 (x64)
Build ID: 60bfb1526849283ce2491346ed2aa51c465abfe6
CPU threads: 4; OS: Windows 10.0; UI render: default;
Locale: es-ES (es_ES); Calc: CL

edit flag offensive delete link more

Comments

This works for me on older versions but not LO 6. However, after I saved the file, closed and reopened it, now it is working. I also went into Tools -> Options -> LibreOffice -> Security and made changes but they did not save, so I'm not sure whether that made a difference or not.

Jim K gravatar imageJim K ( 2018-05-19 16:32:26 +0200 )edit

Question Tools

1 follower

Stats

Asked: 2018-02-12 20:13:45 +0200

Seen: 256 times

Last updated: Feb 12