• 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" extension

1) General

• GOOGLETRANSLATE Text translation in a LibreOffice Calc cell using the Google Translate website
• TRANSLITUA Transliteration of text from Ukrainian to English according to the state standard (Resolution of the Cabinet of Ministers of Ukraine No. 55 of 27.01.2010).
• TRANSLITRU Transliteration of text from Russian to English according to the selected standard
• CLEANTEXT Cleans text from all characters except letters
• CLEANDIGITS Cleans text from all characters except digits
• GETSUBSTR Returns a part of the text using the specified delimiter
• GETNUMBER Getting numbers from text
• GETDATE Getting dates from text
• GETURL Getting website addresses from text
• CONCATIF Concatenating text from different cells according to a specified condition
• SUMBYCELLCOLOR Sums values in cells that have a certain fill color
• SUMBYFONTCOLOR Sums values in cells that have a certain font color
• COUNTBYCELLCOLOR Counts the number of cells that have a certain fill color
• COUNTBYFONTCOLOR Counts the number of cells that have a certain font color
• GETCOMMENT Returns the comment text of the selected cell
• GETSEX Returns gender by analyzing the first name, last name, and patronymic
• GETWORD Returns any word in the text by a specified set of delimiters
• WORKBOOK Returns the name of the current workbook
• SHEETNAME Returns the sheet name by serial number
• TABLETOARRAY Converts values from a table into an array (1 or 2-dimensional)
• TABLETODICT Converts values from a table into a 'dictionary' data type (Python or PHP)
• TABLETOCSV Converts values from a table into text in CSV format
• TABLETOSQL Converts values from a table into an SQL INSERT INTO command
• TABLETOHTML Converts values from a table into HTML format
• TABLETOJSON Converts values from a table into JSON format
• TABLETOXML Converts values from a table into XML format
• WORKHOURS Calculation of the number of working hours between two specified dates and start and end times of work, taking into account weekends and holidays
• ISOCOUNTRY Returns the country code in the selected format. Additional data is also available.
• IMAGE Inserts an image into the specified cell, using a URL.
• QRCODE Inserts a QR code into the specified cell for the specified text.
• BARCODE Inserts a barcode into the specified cell for the specified text.
• GETBOLD Getting text fragments highlighted in bold
• IMPORTTEXT Imports data from a text file
• IMPORTCSV Imports data from a CSV file

2) Amount in words

• SUMINWORDS Displaying a number as an amount 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 numerical values in English with the ability to add the name of any currency

3) VLOOKUP Modifications

• VLOOKUPSEQ Modified VLOOKUP function which can return any match (not just the first one found)
• VLOOKUPDOUBLE Modified VLOOKUP function which searches by two conditions (in two different table columns)
• VLOOKUPMULTI Modified VLOOKUP function which searches across many columns simultaneously
• FUZZYLOOKUP Function for searching for values by approximate match by analogy with VLOOKUP

4) Changing letter case

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

5) Markets

• YFINANCE Getting historical data for a period from the 'Yahoo Finance' website
• FOREX Importing exchange rates from the 'Yahoo Finance' website
• CRYPTO Importing cryptocurrency prices from the 'Yahoo Finance' website (finance.yahoo.com)
• STOCK Importing stock prices from the 'Yahoo Finance' website (finance.yahoo.com)
• BONDS Importing treasury bond prices from the 'Yahoo Finance' website (finance.yahoo.com)
• OPTIONS Importing options prices from the 'Yahoo Finance' website (finance.yahoo.com)
• FUTURES Importing prices for futures contracts from the 'Yahoo Finance' website (finance.yahoo.com)
• ETF Importing prices for shares of exchange-traded funds (ETFs) from the 'Yahoo Finance' website (finance.yahoo.com)
• FUNDS Importing prices for shares of mutual funds (Mutual Funds) from the 'Yahoo Finance' website (finance.yahoo.com)
• PROFILE Getting company data from the 'Yahoo Finance' website
• FINANCIALS Company financial statements from the 'Yahoo Finance' website
• STATISTICS Company financial indicators from the 'Yahoo Finance' website
• DIVIDEND Importing dividend data from the 'Yahoo Finance' website
• CAC_40 Getting stock prices of companies from the 'CAC 40' index from the 'Yahoo Finance' website
• FTSE100 Getting stock prices of companies from the 'FTSE 100' index from the 'Yahoo Finance' website
• NIKKEI225 Getting stock prices of companies from the 'NIKKEI 225' index from the 'Yahoo Finance' website
• DAX Getting stock prices of companies from the 'DAX' index from the 'Yahoo Finance' website

6) AI

• AI Getting information from a large language model
• AIFILL Filling a column with generated data
• AIEXTRACT Getting information from text
• AITRANSLATE Text translation
• AITABLE Generating a table with data
• AILOOKUP Modification of VLOOKUP for fuzzy (approximate) data matching

57) Getting official exchange rates

• NBUA Function for getting exchange rates from the official website of the National Bank of Ukraine (bank.gov.ua)
• NBRU Function for getting exchange rates from the official website of the Central Bank of Russia (cbr.ru)
• NBKZ Function for getting exchange rates from the official website of the National Bank of Kazakhstan (nationalbank.kz)
• NBUZ Function for getting exchange rates from the official website of the Central Bank of Uzbekistan (cbu.uz)
• NBAZ Function for getting exchange rates from the official website of the Central Bank of Azerbaijan (cbar.az)
• NBMD Function for getting exchange rates from the official website of the National Bank of Moldova (bnm.md)
• NBGE Function for getting exchange rates from the official website of the National Bank of Georgia (nbg.gov.ge)
• NBTM Function for getting exchange rates from the official website of the Central Bank of Turkmenistan (cbt.tm)
• NBKG Function for getting exchange rates from the official website of the National Bank of Kyrgyzstan (nbkr.kg)
• NBTJ Function for getting exchange rates from the official website of the National Bank of Tajikistan (nbt.tj)
• NBAM Function for getting exchange rates from the official website of the Central Bank of Armenia (cba.am)
• NBLT Function for getting exchange rates from the official website of the National Bank of Lithuania (lb.lt)
• NBEU Function for getting exchange rates from the official website of the European Central Bank (ecb.eu)
• NBRO Function for getting exchange rates from the official website of the National Bank of Romania (bnro.ro)
• NBBR Function for getting exchange rates from the official website of the Central Bank of Brazil (bcb.gov.br)
• NBIL Function for getting exchange rates from the official website of the Bank of Israel (boi.org.il)
• NBAU Function for getting exchange rates from the official website of the Reserve Bank of Australia (rba.gov.au)
• NBNO Function for getting exchange rates from the official website of Norges Bank (Central Bank of Norway) (norges-bank.no)
• NBCA Function for getting exchange rates from the official website of the Bank of Canada (bankofcanada.ca)
• NBUK Function for getting exchange rates from the official website of the Bank of England (bankofengland.co.uk)
• NBSE Function for getting exchange rates from the official website of Sveriges Riksbank (Central Bank of Sweden) (riksbank.se)
• NBDK Function for getting exchange rates from the official website of Danmarks Nationalbank (Central Bank of Denmark) (nationalbanken.dk)
• NBPL Function for getting exchange rates from the official website of the National Bank of Poland (nbp.pl)
• NBCH Function for getting exchange rates from the official website of the Swiss National Bank (snb.ch)
• NBCZ Function for getting exchange rates from the official website of the Czech National Bank (cnb.cz)
• NBHU Function for getting exchange rates from the official website of the Hungarian National Bank (mnb.hu)