URI Functions

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

WEBSERVICE

አንዳንድ የ ዌብ ይዞታዎችን ያግኙ ከ URI.

አገባብ

የ ዌብ ግልጋሎት(URI)

URI: URI የ ዌብ ግልጋሎት በ ጽሁፍ ነው

ምሳሌዎች

=የ ዌብ ግልጋሎት("wiki.documentfoundation.org/api.php?hidebots=1&days=7&limit=50&action=feedrecentchanges&feedformat=rss")

የ ድህረ ገጽ ይዞታ ይመልሳል ለ "http://wiki.documentfoundation.org/api.php?hidebots=1&days=7&limit=50&action=feedrecentchanges&feedformat=rss".

Technical information

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

መፈጸሚያ የ Xመንገድ መግለጫ ለ XML ሰነድ

አገባብ

ማጣሪያ የ XML(የ XML ሰነድ: የ Xመንገድ መግለጫ)

የ XML ሰነድ (ያስፈልጋል): ዋጋ ያለው የ XML ማስተላለፊያ የያዘ.

የ Xመንገድ መግለጫ (ያስፈልጋል): ዋጋ ያለው የ Xመንገድ መግለጫ የያዘ

ምሳሌዎች

=XML ማጣሪያ(የ ዌብ ግልጋሎት("wiki.documentfoundation.org/api.php?hidebots=1&days=7&limit=50&action=feedrecentchanges&feedformat=rss");"//lastBuildDate")

ዊኪ መጨረሻ የ ተገነባበትን ቀን መረጃ ይመልሳል

Technical information

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

የ URL-መቀየሪያ ሀረግ ይመልሳል

ይህን ተግባር ይጠቄሙ ለ መቀየር ጽሁፍ ከ ምልክቶች ጋር ወደ ፊደሎች: (ለምሳሌ የ አነባበብ ባህሪዎች: non-ASCII ፊደሎች ወይንም የ እሲያን ቃሎች) ወደ ሀረግ ለ URL-መደበኛ ምልክቶች:

አገባብ

ENCODEURL(Text)

ጽሁፍ: የ URL-መደበኛ ምልክቶች ቅደም ተከተል ሀረግ መቀየሪያ

ምሳሌዎች

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

ይህ B1 ክፍል የያዘው ጽሁፍ "車", =ENCODEURL(B1) returns %E8%BB%8A ("車" መኪና ማለት ነው በ ጃፓንኛ)

Technical information

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

WEBSERVICE, FILTERXML, ENCODEURL wiki pages.