[Libreoffice-qa] How should Calc's WEBSERVICE function work?
Hello @ll, 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,demode=xmlunits=metric; in e.g. cell A1 (I have tried it with the German =WEBDIENST http://api.openweathermap.org/data/2.5/forecast?q=Berlin,demode=xmlunits=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 ... :( 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 ... :( Have a nice day Thomas. -- NP: Mechanical Butterfly – The Alchemist ___ List Name: Libreoffice-qa mailing list Mail address: Libreoffice-qa@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/
Re: [Libreoffice-qa] How should Calc's WEBSERVICE function work?
Hey, On Sat, Dec 13, 2014 at 10:15 AM, Thomas Hackert thack...@nexgo.de wrote: Hello @ll, 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,demode=xmlunits=metric in e.g. cell A1 (I have tried it with the German =WEBDIENST http://api.openweathermap.org/data/2.5/forecast?q=Berlin,demode=xmlunits=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. 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. 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 ... :( Have a nice day Thomas Because they help interoperability and there is someone implementing them. Regards, Markus ___ List Name: Libreoffice-qa mailing list Mail address: Libreoffice-qa@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/
Re: [Libreoffice-qa] How should Calc's WEBSERVICE function work?
Hello Markus, *, On Saterday, 13. December 2014 11:00 Markus Mohrhard wrote: On Sat, Dec 13, 2014 at 10:15 AM, Thomas Hackert thack...@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,demode=xmlunits=metric in e.g. cell A1 (I have tried it with the German =WEBDIENST http://api.openweathermap.org/data/2.5/forecast?q=Berlin,demode=xmlunits=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? 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@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/
Re: [Libreoffice-qa] How should Calc's WEBSERVICE function work?
Hey, On Sat, Dec 13, 2014 at 4:14 PM, Thomas Hackert thack...@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 thack...@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,demode=xmlunits=metric in e.g. cell A1 (I have tried it with the German =WEBDIENST http://api.openweathermap.org/data/2.5/forecast?q=Berlin,demode=xmlunits=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@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/ ___ List Name: Libreoffice-qa mailing list Mail address: Libreoffice-qa@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/
Re: [Libreoffice-qa] How should Calc's WEBSERVICE function work?
Hello Markus, *, On Sa, 13. Dezember 2014 18:58 Markus Mohrhard wrote: On Sat, Dec 13, 2014 at 4:14 PM, Thomas Hackert thack...@nexgo.de wrote: On Saterday, 13. December 2014 11:00 Markus Mohrhard wrote: On Sat, Dec 13, 2014 at 10:15 AM, Thomas Hackert thack...@nexgo.de wrote: [WEBSERVICE howto for Calc] 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. O.K. Thanks for the info :) Than I only need to find the instruction, how I can use it ... ;) Thanks for your answer and have a nice evening Thomas. Rest snipped -- Two cars in every pot and a chicken in every garage. ___ List Name: Libreoffice-qa mailing list Mail address: Libreoffice-qa@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/