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, the function uses the "Google Translate" site and can be used in any formulas both independently and together with other standard functions.

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 corresponding 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: " Supported languages "

Extension "YouLibreCalc.oxt"

You can use the function GOOGLETRANSLATE() by setting the extension " YouLibreCalc.oxt ". After that, this function will be available in all files that will be opened in LibreOffice Calc.