Ask Your Question

How to use WEBSERVICE and FILTERXML calc functions?

asked 2016-03-11 10:59:05 +0100

Andrea Borruso gravatar image

updated 2016-03-11 11:05:33 +0100


I'm using LibreOffice (x64) and I would like to make a live import of a remote XML file. The URL is:

I have written this formula, but calc import only the firs row.


Is it normal? How to import all the output of the XPath query?

In gdrive sheet it works with:


Thank you very much

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2016-04-07 00:41:50 +0100

m.a.riosv gravatar image


Entered as array and calling every row, seems a workaround:

A3: ={FILTERXML(WEBSERVICE("");"//main/DATA_RECORD["&ROW()-3&"]")}
edit flag offensive delete link more

answered 2016-03-11 12:43:44 +0100

pierre-yves samyn gravatar image


There is a bug report about this.

m.a.riosv give an example to get an array.


edit flag offensive delete link more


Thank you. I have added my comment to the issue

Andrea Borruso gravatar imageAndrea Borruso ( 2016-03-11 19:19:30 +0100 )edit

And I have reopened again the bug, because the function only return the first value when there are several.

m.a.riosv gravatar imagem.a.riosv ( 2016-04-07 00:34:14 +0100 )edit

Thank you very much m.a.riosv

Andrea Borruso gravatar imageAndrea Borruso ( 2016-04-08 17:49:09 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2016-03-11 10:59:05 +0100

Seen: 2,533 times

Last updated: Apr 07 '16