GoogleTranslate function for LibreOffice Calc

GOOGLETRANSLATE() Description

The GOOGLETRANSLATE() function is designed to translate text directly in a cell on any worksheet.

For text translation, this function uses the "Google Translate" site and can be used in any formulas both independently and together with other standard functions.

You can also use a ready-made tool "Google Translate" , which translates text directly into a cell on any worksheet.

Main Features Functions GOOGLETRANSLATE

Syntax:

=GOOGLETRANSLATE(TextToTranslate; SourceLanguage; TargetLanguage)

Parameters:

• TextToTranslate: A cell with the text you want to translate into another language.
• SourceLanguage: The language of the selected text in the form of a two-letter code.
• TargetLanguage: The language in which you want to translate the text in the form of a two-letter code.

How Does It Work?

Just enter the function GOOGLETRANSLATE in the appropriate cell, specifying the text to be translated, the language of the source text and the language you want to translate into. LibreOffice Calc automatically uses "Google Translate" to provide accurate and fast translation.

Example Usage

Have a cell with the text you want to translate. All you have to do is enter the formula GOOGLETRANSLATE(), and LibreOffice Calc will automatically translate the text:

=GOOGLETRANSLATE(TextToTranslate; SourceLanguage; TargetLanguage)

We will have the following result:

This example uses the following values:

• TextToTranslate: A2 - cell with text for translation ("The quick brown fox jumps over the lazy dog") .
• SourceLanguage: B2 - English (source language) ("en") .
• TargetLanguage: C2 - French (language of translation) ("fr") .

Where can I get a list of languages and their codes?

A complete list of supported languages, as well as their codes, can be obtained from the official Google page: "Language support"

Download the extension

You can use the GOOGLETRANSLATE() function by installing a free extension YouLibreCalc.oxt or its full-featured version YLC_Utilities.oxt .

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