URI Functions

These spreadsheet functions are used for inserting data from Universal Resource Identifiers (URI).

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".

Technical information

tip

This function is available since LibreOffice 4.2.


This function is not part of the Open Document Format for Office Applications (OpenDocument) Version 1.3. Part 4: Recalculated Formula (OpenFormula) Format standard. The name space is

COM.MICROSOFT.WEBSERVICE

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.

Technical information

tip

This function is available since LibreOffice 4.2.


This function is not part of the Open Document Format for Office Applications (OpenDocument) Version 1.3. Part 4: Recalculated Formula (OpenFormula) Format standard. The name space is

COM.MICROSOFT.FILTERXML

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).

Technical information

tip

This function is available since LibreOffice 5.0.


This function is not part of the Open Document Format for Office Applications (OpenDocument) Version 1.3. Part 4: Recalculated Formula (OpenFormula) Format standard. The name space is

COM.MICROSOFT.ENCODEURL

Please support us!