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.
=GOOGLETRANSLATE(TextToTranslate; SourceLanguage; TargetLanguage)
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.
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:
A complete list of supported languages, as well as their codes, can be obtained from the official Google page: "
You can use the function GOOGLETRANSLATE() by setting the extension "