Ask Your Question
0

Problem with FILTERXML-Function in Basic (IllegalArgumentException)

asked 2016-12-25 12:16:08 +0200

Ralph_E gravatar image

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/lib...) 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

edit retag flag offensive close merge delete

3 Answers

Sort by » oldest newest most voted
0

answered 2016-12-26 01:04:09 +0200

Regina gravatar image

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

edit flag offensive delete link more
0

answered 2017-03-19 22:27:56 +0200

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.

edit flag offensive delete link more
0

answered 2016-12-29 20:57:04 +0200

Ralph_E gravatar image

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

edit flag offensive delete link more

Comments

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.

Ratslinger gravatar imageRatslinger ( 2017-03-20 15:19:25 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2016-12-25 12:16:08 +0200

Seen: 136 times

Last updated: Mar 19