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