GoogleTranslate function for LO Calc

GOOGLETRANSLATE() Description

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

To translate text, this function uses "Google Translate" website and can be used in any formulas, both independently and in conjunction with other standard functions.

You can also use ready-made with the Google Translate tool , which translates text directly in 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 as 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?

Simply enter the GOOGLETRANSLATE function in the appropriate cell, specifying the text to translate, the source language, and the language you want to translate to. LO Calc will automatically use "Google Translate" to provide accurate and fast translation.

Example Usage

Suppose you have a cell with the text you want to translate. All you have to do is enter the formula GOOGLETRANSLATE(), and LO Calc 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 to translate ("The quick brown fox jumps over the lazy dog") .
• SourceLanguage: B2 - English (text language) ("EN") .
• TargetLanguage: C2 - French (translation language) ("FR") .

Where to Get a List of Languages and Their Codes?

A full list of supported languages, as well as their codes, can be found on the official Google page: "Language support"

Download extension

You can use the function GOOGLETRANSLATE() by installing the extension YLC Utilities .

Or its free version YouLibreCalc .

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