Functions and formulae translator

Discuss the spreadsheet application
Post Reply
gerard24
Volunteer
Posts: 958
Joined: Sat Oct 30, 2010 5:12 pm
Location: France

Functions and formulae translator

Post by gerard24 »

Hello,

Last year, i had created a file to translate formulae.
Now i want to translate explanations and comments and i need your help.

The sentences to be translated are In the last sheet (called UI). Translation has to be made in the cell just below the french sentence.
I want a translation in English, German & Spanish. So if french speaking can help me...

For the German and Spanish, may be you can wait for an english version and base your translation on.

Thanks in advance.

Gérard.
traducteur_formule_RC1.ods
New file (29/07/2011)
(107.67 KiB) Downloaded 169 times
Last edited by gerard24 on Fri Jul 29, 2011 8:41 pm, edited 1 time in total.
LibreOffice 6.4.5 on Windows 10
User avatar
Hagar Delest
Moderator
Posts: 30983
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: Functions and formulae translator

Post by Hagar Delest »

Here is a proposal for English, if an English user could have a look to correct it, that would be great.
I've to admit that I haven't really understood the part about installing a new language (especially the "copy" range to be copied and pasted).
traducteur_formule_RC1.ods
(104.52 KiB) Downloaded 166 times
LibreOffice 7.4 on Xubuntu 22.10 and 7.4 portable on Windows 10
gerard24
Volunteer
Posts: 958
Joined: Sat Oct 30, 2010 5:12 pm
Location: France

Re: Functions and formulae translator

Post by gerard24 »

Thanks for your work. :)
With this, i saw few mistakes needed to be corrected in my formulae.
Hagar de l'Est wrote: I've to admit that I haven't really understood the part about installing a new language (especially the "copy" range to be copied and pasted).
If you have severals langpacks (for example Australian langpack).
You change User Interface in Tools > Options > Language settings.
Range name "Copy" (column D sheet lang_pack) contains Functions names in Australian.
You copy this range and paste in the last colum of sheet Liste_fonctions.

And you have a new language for Function names.

Bad example, i think Australian used English names. :(

Gérard
LibreOffice 6.4.5 on Windows 10
User avatar
Hagar Delest
Moderator
Posts: 30983
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: Functions and formulae translator

Post by Hagar Delest »

OK, I see. A screenshot would be useful I guess (showing the 'copy' string in the name box.
Note that there is no equivalent to "Chaîne de caractères", it's only "Text".
LibreOffice 7.4 on Xubuntu 22.10 and 7.4 portable on Windows 10
User avatar
RoryOF
Moderator
Posts: 33791
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Functions and formulae translator

Post by RoryOF »

You could perhaps use "sequence of text characters", or "text string", or even "character string"
Apache OpenOffice 4.1.13 on Xubuntu 22.04.1 LTS and very infrequently on Win2K/XP
User avatar
Hagar Delest
Moderator
Posts: 30983
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: Functions and formulae translator

Post by Hagar Delest »

I mean in the options for paste special.
LibreOffice 7.4 on Xubuntu 22.10 and 7.4 portable on Windows 10
gerard24
Volunteer
Posts: 958
Joined: Sat Oct 30, 2010 5:12 pm
Location: France

Re: Functions and formulae translator

Post by gerard24 »

Hagar de l'Est wrote:I mean in the options for paste special.
Yes, it is "text" in english and "texte" in french with LibO. I think it was "chaine de caractères" in previous version.
My mistake. :oops:
LibreOffice 6.4.5 on Windows 10
User avatar
MrProgrammer
Moderator
Posts: 4465
Joined: Fri Jun 04, 2010 7:57 pm
Location: Wisconsin, USA

Re: Functions and formulae translator

Post by MrProgrammer »

Please allow me to offer an English translation. My native language is English (central United States). This is based on Hagar's translation but I have updated sheet UI cells G8, H8, U8, AH8, AI8, B14, B20, B26, B32, B38, B44, B50, B62, B68, I80, B92, F92, I92, I98, G104, B116, I116, B122, I122, B128, I128, B134, A138, B138, A139, B139, A140, and A141.

In B134 I changed the cell name from E7 to F7. I believe you want that in other languages, too.

I also added instructions for Mac users in several places.

In sheet liste fonctions, I updated a few of the names in column D to include the _ADD suffix.

Thank you for providing this spreadsheet. I'm sure others will find it helpful. Volunteers here will be able to use it to assist people who use a non-English locale.
Attachments
Formula_translator_RC1.ods
(92.45 KiB) Downloaded 165 times
Mr. Programmer
AOO 4.1.7 Build 9800 on MacOS 10.14.6.   The locale for any menus or Calc formulas in my posts is English (USA).
gerard24
Volunteer
Posts: 958
Joined: Sat Oct 30, 2010 5:12 pm
Location: France

Re: Functions and formulae translator

Post by gerard24 »

I don't have time to read all your changes, but many thanks for this.

Now, if i could have translation in German (and spanish) it would be nice.
After, I will make some adjustments and this spreadsheet will be ready for use.
LibreOffice 6.4.5 on Windows 10
User avatar
Villeroy
Volunteer
Posts: 30875
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Functions and formulae translator

Post by Villeroy »

For the casual reader. I know it is not the same:
A macro to get and set the stored (English) version of a localized formula: http://www.oooforum.org/forum/viewtopic.phtml?t=23270
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
User avatar
MrProgrammer
Moderator
Posts: 4465
Joined: Fri Jun 04, 2010 7:57 pm
Location: Wisconsin, USA

Re: Functions and formulae translator

Post by MrProgrammer »

You'll want to turn on Format > Cells > Alignment > Wrap for cell F9. The user can't do it because the cell is protected.
Screen shot 2011-07-29 at 11.52.29 .png
Mr. Programmer
AOO 4.1.7 Build 9800 on MacOS 10.14.6.   The locale for any menus or Calc formulas in my posts is English (USA).
gerard24
Volunteer
Posts: 958
Joined: Sat Oct 30, 2010 5:12 pm
Location: France

Re: Functions and formulae translator

Post by gerard24 »

New file in the 1st post with modifications.

If you want to modify or have a look at formulae, password for this one is "Calc" (without quotes).
LibreOffice 6.4.5 on Windows 10
Post Reply