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

[Thomas Hackert]

Hello Miguel, *,
On Sat, 13. December 2014 20:48 m.a.riosv wrote:

> They were recently incorporated by Olivier Hallot into the help.
> https://bugs.freedesktop.org/show_bug.cgi?id=80441
> 
> Help link with an example:
> WEBSERVICE FILTERXML help
> 


thank you for the link, but I have found it during my translation to 
German in the meantime ... ;)
Thanks again and have a nice evening
Thomas.

-- 
Love is not enough, but it sure helps.

___
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?

[m.a.riosv]

They were recently incorporated by Olivier Hallot into the help.
https://bugs.freedesktop.org/show_bug.cgi?id=80441

Help link with an example:
WEBSERVICE FILTERXML help

  

Miguel Ángel.



--
View this message in context: 
http://nabble.documentfoundation.org/Libreoffice-qa-How-should-Calc-s-WEBSERVICE-function-work-tp4132481p4132512.html
Sent from the QA mailing list archive at Nabble.com.
___
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?

[Thomas Hackert]

Hello Markus, *,
On Sa, 13. Dezember 2014 18:58 Markus Mohrhard wrote:
> On Sat, Dec 13, 2014 at 4:14 PM, Thomas Hackert
>  wrote:
>> On Saterday, 13. December 2014 11:00 Markus Mohrhard wrote:
>> > On Sat, Dec 13, 2014 at 10:15 AM, Thomas Hackert
>> >  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.



-- 
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/

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

[Markus Mohrhard]

Hey,

On Sat, Dec 13, 2014 at 4:14 PM, Thomas Hackert  wrote:
>
> Hello Markus, *,
> On Saterday, 13. December 2014 11:00 Markus Mohrhard wrote:
> > On Sat, Dec 13, 2014 at 10:15 AM, Thomas Hackert
> >  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@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?

[Thomas Hackert]

Hello Markus, *,
On Saterday, 13. December 2014 11:00 Markus Mohrhard wrote:
> On Sat, Dec 13, 2014 at 10:15 AM, Thomas Hackert
>  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?

>> 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?

[Markus Mohrhard]

Hey,

On Sat, Dec 13, 2014 at 10:15 AM, Thomas Hackert  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,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. 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/

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

[Thomas Hackert]

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,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 ... :(

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/