From 6c2abb8601836f6bea02b7dfabba486208f2c6be Mon Sep 17 00:00:00 2001 From: Olivier Hallot Date: Mon, 26 Nov 2018 14:48:59 -0200 Subject: tdf#120927 Webservice functions needs linking to Change-Id: I8d96025238fc2005dab37c1050a0c7915210d73a Reviewed-on: https://gerrit.libreoffice.org/64055 Tested-by: Jenkins Reviewed-by: Olivier Hallot --- source/text/scalc/01/04060110.xhp | 9 +++ source/text/scalc/01/func_webservice.xhp | 124 ++++++++++++++++--------------- 2 files changed, 75 insertions(+), 58 deletions(-) diff --git a/source/text/scalc/01/04060110.xhp b/source/text/scalc/01/04060110.xhp index 6f50c90964..c582ffc300 100644 --- a/source/text/scalc/01/04060110.xhp +++ b/source/text/scalc/01/04060110.xhp @@ -777,6 +777,15 @@ =VALUE("4321") returns 4321. +
+ +
+
+ +
+
+ +
diff --git a/source/text/scalc/01/func_webservice.xhp b/source/text/scalc/01/func_webservice.xhp index 0401cf023b..e74e1613b7 100644 --- a/source/text/scalc/01/func_webservice.xhp +++ b/source/text/scalc/01/func_webservice.xhp @@ -1,62 +1,70 @@ +* This file is part of the LibreOffice project. +* +* This Source Code Form is subject to the terms of the Mozilla Public +* License, v. 2.0. If a copy of the MPL was not distributed with this +* file, You can obtain one at http://mozilla.org/MPL/2.0/. +* +--> - - - URI Functions - /text/scalc/01/func_webservice.xhp - - - -
- WEBSERVICE function - - - WEBSERVICE - Get some web content from a URI. - - WEBSERVICE(URI) - URI: URI text of the web service. - - =WEBSERVICE("wiki.documentfoundation.org/api.php?hidebots=1&days=7&limit=50&action=feedrecentchanges&feedformat=rss") - Returns the web page content of "https://wiki.documentfoundation.org/api.php?hidebots=1&days=7&limit=50&action=feedrecentchanges&feedformat=rss". -
-
- - - FILTERXML function - - FILTERXML - Apply a XPath expression to a XML document. - - FILTERXML(XML Document; XPath expression) - XML Document (required): String containing a valid XML stream. - XPath expression (required): String containing a valid XPath expression. - - =FILTERXML(WEBSERVICE("wiki.documentfoundation.org/api.php?hidebots=1&days=7&limit=50&action=feedrecentchanges&feedformat=rss");"//lastBuildDate") - Returns information on the last build date of the wiki. -
-
- - - ENCODEURL function - - ENCODEURL function - Returns a URL-encoded string. - Use this function to transform text with symbols of national alphabets (for example accented characters, non-ASCII alphabets or Asian words) to a string of URL-standard symbols. - - ENCODEURL(Text) - Text: String to encode to a sequence of URL-standard symbols. - - If cell A1 contains the Cyrillic text "автомобиль", =ENCODEURL(A1) returns %D0%B0%D0%B2%D1%82%D0%BE%D0%BC%D0%BE%D0%B1%D0%B8%D0%BB%D1%8C (the word "автомобиль" means car in Russian). - If cell B1 contains the text "車", =ENCODEURL(B1) returns %E8%BB%8A ("車" means car in Japanese). -
- + + + URI Functions + /text/scalc/01/func_webservice.xhp + + + +
+ + WEBSERVICE function + + +
+ WEBSERVICE + Get some web content from a URI. +
+ + WEBSERVICE(URI) + URI: URI text of the web service. + + =WEBSERVICE("wiki.documentfoundation.org/api.php?hidebots=1&days=7&limit=50&action=feedrecentchanges&feedformat=rss") + Returns the web page content of "https://wiki.documentfoundation.org/api.php?hidebots=1&days=7&limit=50&action=feedrecentchanges&feedformat=rss". +
+
+ + + FILTERXML function + +
+ FILTERXML + Apply a XPath expression to a XML document. +
+ + FILTERXML(XML Document; XPath expression) + XML Document (required): String containing a valid XML stream. + XPath expression (required): String containing a valid XPath expression. + + =FILTERXML(WEBSERVICE("wiki.documentfoundation.org/api.php?hidebots=1&days=7&limit=50&action=feedrecentchanges&feedformat=rss");"//lastBuildDate") + Returns information on the last build date of the wiki. +
+
+ + + ENCODEURL function + +
+ ENCODEURL + Returns a URL-encoded string. +
+ Use this function to transform text with symbols of national alphabets (for example accented characters, non-ASCII alphabets or Asian words) to a string of URL-standard symbols. + + ENCODEURL(Text) + Text: String to encode to a sequence of URL-standard symbols. + + If cell A1 contains the Cyrillic text "автомобиль", =ENCODEURL(A1) returns %D0%B0%D0%B2%D1%82%D0%BE%D0%BC%D0%BE%D0%B1%D0%B8%D0%BB%D1%8C (the word "автомобиль" means car in Russian). + If cell B1 contains the text "車", =ENCODEURL(B1) returns %E8%BB%8A ("車" means car in Japanese). +
+ -- cgit