<div dir="ltr">Hey, <div class="gmail_extra"> <div class="gmail_quote">On Sat, Dec 13, 2014 at 4:14 PM, Thomas Hackert <<a href="mailto:thackert@nexgo.de" target="_blank">thackert@nexgo.de</a>> wrote:<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Hello Markus, *, On Saterday, 13. December 2014 11:00 Markus Mohrhard wrote: > On Sat, Dec 13, 2014 at 10:15 AM, Thomas Hackert > <<a href="mailto:thackert@nexgo.de">thackert@nexgo.de</a>> 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 >> " >> <a href="http://api.openweathermap.org/data/2.5/forecast?q=Berlin,de&mode=xml&units=metric" target="_blank">http://api.openweathermap.org/data/2.5/forecast?q=Berlin,de&mode=xml&units=metric</a> >> "" >> in e.g. cell A1 (I have tried it with the German "=WEBDIENST >> " >> <a href="http://api.openweathermap.org/data/2.5/forecast?q=Berlin,de&mode=xml&units=metric" target="_blank">http://api.openweathermap.org/data/2.5/forecast?q=Berlin,de&mode=xml&units=metric</a> >> ""). >> >> 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? </blockquote><div> </div><div>They were implemented together about a year and a half ago. </div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"> >> 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 <div class="HOEnZb"><div class="h5"> _______________________________________________ List Name: Libreoffice-qa mailing list Mail address: <a href="mailto:Libreoffice-qa@lists.freedesktop.org">Libreoffice-qa@lists.freedesktop.org</a> Change settings: <a href="http://lists.freedesktop.org/mailman/listinfo/libreoffice-qa" target="_blank">http://lists.freedesktop.org/mailman/listinfo/libreoffice-qa</a> Problems? <a href="http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/" target="_blank">http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/</a> Posting guidelines + more: <a href="http://wiki.documentfoundation.org/Netiquette" target="_blank">http://wiki.documentfoundation.org/Netiquette</a> List archive: <a href="http://lists.freedesktop.org/archives/libreoffice-qa/" target="_blank">http://lists.freedesktop.org/archives/libreoffice-qa/</a></div></div></blockquote></div></div></div>