[Libreoffice-qa] How should Calc's WEBSERVICE function work?

[Markus Mohrhard]

Hey,

On Sat, Dec 13, 2014 at 4:14 PM, Thomas Hackert <thackert at nexgo.de> wrote:
>
> Hello Markus, *,
> On Saterday, 13. December 2014 11:00 Markus Mohrhard wrote:
> > On Sat, Dec 13, 2014 at 10:15 AM, Thomas Hackert
> > <thackert at nexgo.de> wrote:
> >> either I do not understand this function (which might be ... ;) )
> >> or I found a bug in it ... :(
> >>
> >> When I
> >> 1. start Calc
> >> 2. then enter, for example, "=WEBSERVICE
> >> "
> >>
>
> http://api.openweathermap.org/data/2.5/forecast?q=Berlin,de&mode=xml&units=metric
> >> ""
> >> in e.g. cell A1 (I have tried it with the German "=WEBDIENST
> >> "
> >>
>
> http://api.openweathermap.org/data/2.5/forecast?q=Berlin,de&mode=xml&units=metric
> >> "").
> >>
> >> I get a cell with a lot of XML data in A1. Is this a feature or a
> >> bug? I had expected, that Calc would insert all the data in
> >> different cells, but without the XML code around ... :(
> >
> > This is expected.
>
> ah, O.K.
>
> > It will just return the data that the url
> > provides. There is no calc function that will return data to
> > multiple cells. Normally you would further process that content
> > with FILTERXML to get the data that you need.
>
> Will this "FILTERXML" function be implemented as well?
>

They were implemented together about a year and a half ago.


> >> BTW: Why are there that much M$ Excel functions flooding Pootle?
> >> It is really time consuming to find out, if they are patented, or
> >> protected by any other rights ... :(
> >
> > Because they help interoperability and there is someone
> > implementing them.
>
> But are we allowed to use them in LO (and for me as a translator:
> Are we allowed to translate them)? Would this not lead to any
> copyright infringement and therefore lawsuits in the US / EU against
> us?
> Thanks for your answer
> Thomas.
>
> --
> NP: Mirrors of Obsidian – Slaves to Numbers
>
> _______________________________________________
> List Name: Libreoffice-qa mailing list
> Mail address: Libreoffice-qa at lists.freedesktop.org
> Change settings:
> http://lists.freedesktop.org/mailman/listinfo/libreoffice-qa
> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://lists.freedesktop.org/archives/libreoffice-qa/
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freedesktop.org/archives/libreoffice-qa/attachments/20141213/6ccc57b3/attachment.html>