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

A complete list of functions included in the YouLibreCalc.xlam extension

1) General

• GOOGLETRANSLATE Translation of the text in cell Excel using the Google Translate site
• TRANSLITUA Transliteration of the text from the Ukrainian language into English according to the state standard (Resolution of the Cabinet of Ukraine No. 55 dated 27.01.2010).
• CLEANTEXT Clears the text of all characters except letters
• CLEANDIGITS Cleans the text of all characters except numbers
• GETSUBSTR Returns a portion of text using the specified delimiter
• GETNUMBER Obtaining numbers from text
• GETDATE Getting dates from text
• GETURL Obtaining site addresses from text
• CONCATIF Connection of text from different cells according to a given condition

2) Amount in writing

• SUMINWORDS Displaying a number in the form of a written sum. Three languages are available - Ukrainian, English and Russian. Also, the user can choose three currencies - hryvnia, dollar or ruble.
• SUMINWORDSVAT Display of the number in the form of a written sum with VAT in Ukrainian in hryvnias.
• SPELLNUMBER A 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 that can return any match (not just the first one found)
• VLOOKUPDOUBLE Modified function VLOOKUP, which performs a search by two conditions (in two different columns of the table)
• VLOOKUPMULTI Modified function VLOOKUP, which performs a search on many columns at the same time
• FUZZYLOOKUP A function for searching for values by an approximate match by analogy with VLOOKUP

4) Changing 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 Converting a string of words into the following format: "snake_case_function"
• KEBABCASE Converting a string of words into the following format: "kebab-case-function"
• BREAKCASE Converting a string of words into the following format: "break case function"
• SENTENCECASE Converting a string of words into the following format: "Sentence case function"
• TITLECASE Converting a string of words into the following format: "Function for Title Case"
• FIRSTCASE Convert the first letter of the 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 exchange rates from the official website of the National Bank of Ukraine (bank.gov.ua)