Problem with FILTERXML-Function in Basic (IllegalArgumentException)

[Ralph_E]

I would like to use the FILTERXML-Function in a Basic-macro, but I always get an IllegalArgumentException. Even using the example from Leif Lodahl’s blog (http://lodahl.blogspot.de/2013/12/libreoffice-now-has-built-in-xml-parser.html) does not work for me. Here’s the code snippet:

*Dim oFunctionAccess 
oFunctionAccess = GetProcessServiceManager().createInstance( "com.sun.star.sheet.FunctionAccess" )   
data = oFunctionAccess.callFunction("WEBSERVICE",array("http://www.lipsum.com/feed/xml?amount=2&what=paras&start=Yes"))
Lipsum = oFunctionAccess.callFunction("FILTERXML", array(data, "/feed/lipsum" ))*

Curious: in the spreadsheet the FILTERXML-function returns the correct values.

I’m using LO V.5.2.4.2.

Any ideas or own experiences appreciated!
Thanks!

Ralph

[Regina]

I can confirm, that there is a problem with FILTERXML, if called via FunctionAccess. Please write a bug report for it.

[Ralph_E]

@Regina: Thank for confirming the problem. Filed a bugreport (see https://bugs.documentfoundation.org/show_bug.cgi?id=104989). Hope it will be fixed soon as it is an interesting function.

[Ratslinger]

As a note, this function had been working in previous versions as tested on Mint 18. The last version I found it working in was 5.2.0.4 and NOT working in 5.2.3.3 (had no versions in between). I have added this comment to the bug report mentioned.

[sherman]

When does this bug finally be fixed?
I use this function in my macros and since I upgraded to 5.3 I got the mess, that it is not working anymore?!
Meanwhile there was an update to 5.3.1.2 in my distro but /wo remedy.
Even in the Bugzilla – Bug Report 104989 there is still no assignee till today to fix it. Status remains “new”.

Hopefully there will be soon a fix for that.