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,
=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
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.