Ask Your Question
0

Problem with FILTERXML-Function in Basic (IllegalArgumentException) [closed]

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

Ralph_E gravatar image

updated 2020-09-27 23:23:50 +0100

Alex Kemp 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 reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-09-27 23:24:25.753758

3 Answers

Sort by » oldest newest most voted
0

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

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 +0100 )edit
0

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

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-26 01:04:09 +0100

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

Question Tools

1 follower

Stats

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

Seen: 333 times

Last updated: Mar 19 '17