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

Complete List of features that are included in the extension "ylc_utilites.xlam"

1) General

• GOOGLETRANSLATE Translating text in LibreOffice Calc cell using Google Translator
• TRANSLITUA Transliteration of text from the Ukrainian language into English according to the State Standard (Cabinet Resolution of Ukraine No. 55 of 27.01.2010).
• TRANSLITRU Transliterate text from Russian to English according to the selected standard
• CLEANTEXT Cleans the text from all characters except the letters
• CLEANDIGITS Cleans the text from all characters except the numbers
• GETSUBSTR Returns a portion of the text using the specified separator
• GETNUMBER Obtaining numbers from the text
• GETDATE Obtaining dates from text
• GETURL Receiving sites from text
• CONCATIF Connecting text from different cells by a given condition
• SUMBYCELLCOLOR Summarizes the value in cells that have a certain color of pouring
• SUMBYFONTCOLOR Summarizes the value in cells that have a certain font color
• COUNTBYCELLCOLOR Calculates the number of cells that have a certain color of pouring
• COUNTBYFONTCOLOR Calculates the number of cells that have a particular font color
• GETCOMMENT Returns the text of the comment of the selected cell
• GETSEX Returns gender by analyzing the name, last name and patronymic
• GETWORD Returns any word in the text by a given set of separators
• WORKBOOK Returns the name of the current book
• SHEETNAME Returns the name of the sheet on the order number
• TABLETOARRAY Converts values from table to an array (1 or 2-dimensional)
• TABLETODICT Converts value from table into a dictionary type (Python or Php)
• TABLETOCSV Converts value from table to text in "CSV" format
• TABLETOSQL Converts the value from the table to SQL command Insrt Into
• TABLETOHTML Converts the value from the table in HTML format
• TABLETOJSON Converts the value from the table in JSON format
• TABLETOXML Converts value from table in XML format
• WORKHOURS Calculation of the number of working hours between two given dates and time of start and end of work taking into account weekends and holidays
• ISOCOUNTRY Returns the country's code in the selected format. Additional data is also available.

2) the sum of the words

• SUMINWORDS Displaying the number in the form of the amount of words. Three languages are available - Ukrainian, English and Russian. Also, the user can choose three currencies - hryvnia, dollar or ruble.
• SUMINWORDSVAT Displaying the number in the form of a amount of VAT in Ukrainian in UAH.
• SPELLNUMBER Custom function to write numerical values in English with the ability to add the name of any currency

3) Vlookup modifications

• VLOOKUPSEQ Modified Vlookup feature that can return any coincidence (not only the first found)
• VLOOKUPDOUBLE A modified Vlookup feature that searches on two conditions (in two different columns of table)
• VLOOKUPMULTI A modified Vlookup feature that searches for many columns at a time
• FUZZYLOOKUP Function to find values by approximate coincidence by analogy with Vlookup

4) Changing the letters register

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

5) Markets

• CRYPTO Import of cryptocurrency prices from 'Yahoo Finance' (Finance.yahoo.com)
• STOCK Import of stock prices from 'Yahoo Finance' (Finance.yahoo.com)

6) Obtaining official currency exchange rates

• NBUA Function to obtain currency rates from the official site of the National Bank of Ukraine (Bank.gov.ua)
• NBRU Function to obtain currency rates from the official site of the Central Bank of Russia (CBR.RU)
• NBKZ Function to obtain currency rates from the official site of the National Bank of Kazakhstan (Nationalbank.kz)
• NBUZ Function to obtain currency rates from the official site of Central Bank Uzbekistan (cbu.uz)
• NBAZ Function to obtain currency rates from the official site of the Central Bank of Azerbaijan (CBar.AZ)
• NBMD Function to obtain currency rates from the official site of the National Bank of Moldova (BNM.MD)
• NBGE Function to obtain currency rates from the official website of the National Bank of Georgia (NBG.gov.GE)
• NBTM Function to obtain currency rates from the Turkmenistan Central Bank's official site (CBT.TM)
• NBKG Function to obtain currency rates from the official site of the National Bank of Kyrgyzstan (NBKR.KG)
• NBTJ Function to obtain currency rates from the official site of Tajikistan National Bank (NBT.TJ)
• NBAM Function to obtain currency rates from the official site of the Central Bank of Armenia (cba.am)
• NBLT Function to obtain currency rates from the official site of the National Bank of Lithuania (lb.lt)
• NBEU Function to obtain currency rates from the official site of Central Bank of Europe (ECB.EU)
• NBRO Function to obtain currency rates from the official site of the National Bank of Romania (BNRO.RO)
• NBBR Function to obtain currency rates from the Brazil Central Bank's official site (bcb.gov.br)
• NBIL Function to obtain currency rates from the official site of the Israeli Bank (boi.org.il)
• NBAU Function to obtain currency rates from the official site of the Australia Reserve Bank (rba.gov.au)
• NBNO Function to obtain currency rates from the official site of the Central Bank of Norway (Norges- Bank.no)
• NBCA Function to obtain currency rates from the official site of the Central Bank of Canada (Bankofcanada.ca)