• UA
• RU
• EN
• ⯈
  ES JA DE HI AR CN PT FR IT KO PL RO TR

Complete list of functions included in the "YLC_Utilities.xlam" extension

1) General

• GOOGLETRANSLATE Translation of the text in the cell LibreOffice Calc using the Google Translate site
• TRANSLITUA Transliteration of text from Ukrainian into English according to the state standard (Resolution of the Cabinet of Ministers of Ukraine No. 55 of 01/27/2010).
• TRANSLITRU Transliteration of text from Russian to English according to the selected standard
• CLEANTEXT Cleans text of all characters except letters
• CLEANDIGITS Cleans text of all characters except numbers
• GETSUBSTR Returns a portion of text using the specified delimiter
• GETNUMBER Getting numbers from text
• GETDATE Getting dates from text
• GETURL Getting website addresses from text
• CONCATIF Combining text from different cells based on a given condition
• SUMBYCELLCOLOR Sums the values in cells that have a specific fill color
• SUMBYFONTCOLOR Sums the values in cells that have a specific font color
• COUNTBYCELLCOLOR Counts the number of cells that have a specific fill color
• COUNTBYFONTCOLOR Counts the number of cells that have a specific font color
• GETCOMMENT Returns the comment text of the selected cell
• GETSEX Returns gender by parsing first name, last name, and middle name
• GETWORD Returns any word in the text according to the given set of delimiters
• WORKBOOK Returns the title of the current book
• SHEETNAME Returns the sheet name by serial number
• TABLETOARRAY Converts values from a table to an array (1 or 2-dimensional)
• TABLETODICT Converts values from a table to the 'dictionary' data type (Python or PHP)
• TABLETOCSV Converts values from a table to text in "csv" format
• TABLETOSQL Converts values from a table to SQL using the INSERT INTO command
• TABLETOHTML Converts values from a table to HTML format
• TABLETOJSON Converts values from a table to JSON format
• TABLETOXML Converts values from a table to XML format
• WORKHOURS Calculation of the number of working hours between two given dates and start and end times, taking into account weekends and holidays
• ISOCOUNTRY Returns the country code in the selected format. Additional data is also available.

2) Amount in words

• SUMINWORDS Display of a number as a sum in words. Three languages are available - Ukrainian, English and Russian. Also, the user can choose three currencies - hryvnia, dollar or ruble.
• SUMINWORDSVAT Displaying a number as an amount in words with VAT in Ukrainian in hryvnias.
• SPELLNUMBER Custom function for writing numeric values in English with the ability to add the name of any currency

3) Modifications VLOOKUP

• VLOOKUPSEQ Modified VLOOKUP function that can return any match (not just the first one found)
• VLOOKUPDOUBLE Modified VLOOKUP function, which searches for two conditions (in two different columns of the table)
• VLOOKUPMULTI Modified VLOOKUP function that searches across many columns at once
• FUZZYLOOKUP Function for searching values by approximate match, similar to VLOOKUP

4) Change the case of letters

• PASCALCASE Converting a string of words into the following format: "PascalCaseFunction"
• CAMELCASE Converting a string of words into the following format: "camelCaseFunction"
• SNAKECASE Convert a string of words into the following format: "snake_case_function"
• KEBABCASE Convert a string of words into the following format: "kebab-case-function"
• BREAKCASE Convert a string of words into the following format: "break case function"
• SENTENCECASE Convert a string of words into the following format: "Sentence case function"
• TITLECASE Convert a string of words into the following format: "Function for Title Case"
• FIRSTCASE Convert the first letter in text to uppercase without changing the rest of the letters, for example: "Function for the First letter Case"

5) Obtaining official exchange rates

• NBUA Function for obtaining currency rates from the official website of the National Bank of Ukraine (bank.gov.ua)
• NBRU Function for obtaining exchange rates from the official website of the Central Bank of Russia (cbr.ru)
• NBKZ Function for obtaining currency rates from the official website of the National Bank of Kazakhstan (nationalbank.kz)
• NBUZ Function for obtaining currency rates from the official website of the Central Bank of Uzbekistan (cbu.uz)
• NBAZ Function for obtaining currency rates from the official website of the Central Bank of Azerbaijan (cbar.az)
• NBMD Function for obtaining exchange rates from the official website of the National Bank of Moldova (bnm.md)
• NBGE Function for obtaining currency rates from the official website of the National Bank of Georgia (nbg.gov.ge)
• NBTM Function for obtaining currency rates from the official website of the Central Bank of Turkmenistan (cbt.tm)
• NBKG Function for obtaining currency rates from the official website of the National Bank of Kyrgyzstan (nbkr.kg)
• NBTJ Function for obtaining currency rates from the official website of the National Bank of Tajikistan (nbt.tj)
• NBAM Function for obtaining currency rates from the official website of the Central Bank of Armenia (cba.am)
• NBLT Function for obtaining currency rates from the official website of the National Bank of Lithuania (lb.lt)
• NBEU Function for obtaining exchange rates from the official website of the Central Bank of Europe (ecb.eu)
• NBRO Function to obtain exchange rates from the official website of the National Bank of Romania (bnro.ro)
• NBBR Function to obtain exchange rates from the official website of the Central Bank of Brazil (bcb.gov.br)