TranslitRu function

TRANSLITRU() Description

The TRANSLITRU() function is intended for transliteration of Russian text into Latin.

Main Features Functions TRANSLITRU

Syntax:

=TRANSLITRU(Text; [Standard])

Parameters:

• Text: The text is in Russian, which must be transliterated into Latin.
• [Standard]: Optional. Transliteration standards :
  0. General standard. It is selected by default.
  1. International standard ICAO (Doc 9303) . It is used for transliteration of foreign passports and driver's licenses.
  2. State standard ГОСТ 7.79-2000 (ISO 9) .
  3. International standard BGN/PCGN (1944) .
  4. International standard BGN/PCGN (1944) with replacement of word endings "ий" and "ый" he "y" .

Example Usage

The TRANSLITRU() function is easy to use. All you have to do is enter any text in Russian and select the transliteration standard, and LibreOffice Calc will automatically convert it into Latin:

=TRANSLITRU("Паниковский Михаил Самуэлевич"; 0)

We will have the following result:

This example uses the following values:

• Text: A2 - Text for transliteration ("Паниковский Михаил Самуэлевич") .
• Standard: B2 - General standard of transliteration (0) .

Download the extension

You can use the TRANSLITRU() function by installing the extension YLC_Utilities.oxt .

After that, this function will be available in all files that will be opened in LibreOffice Calc.