Functions and formulae translator

Discuss the spreadsheet application

Functions and formulae translator

Postby gerard24 » Sun Jun 19, 2011 3:36 pm

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 141 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
gerard24
Volunteer
 
Posts: 958
Joined: Sat Oct 30, 2010 5:12 pm
Location: France

Re: Functions and formulae translator

Postby Hagar Delest » Sun Jun 19, 2011 5:34 pm

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 143 times
LibreOffice 7.2.1 on Xubuntu 21.04 and 7.2.1 portable on Windows 10
User avatar
Hagar Delest
Moderator
 
Posts: 30168
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: Functions and formulae translator

Postby gerard24 » Sun Jun 19, 2011 5:51 pm

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
gerard24
Volunteer
 
Posts: 958
Joined: Sat Oct 30, 2010 5:12 pm
Location: France

Re: Functions and formulae translator

Postby Hagar Delest » Sun Jun 19, 2011 6:34 pm

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.2.1 on Xubuntu 21.04 and 7.2.1 portable on Windows 10
User avatar
Hagar Delest
Moderator
 
Posts: 30168
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: Functions and formulae translator

Postby RoryOF » Sun Jun 19, 2011 6:38 pm

You could perhaps use "sequence of text characters", or "text string", or even "character string"
Apache OpenOffice 4.1.10 on Xubuntu 20.04.3 and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 33185
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Functions and formulae translator

Postby Hagar Delest » Sun Jun 19, 2011 8:57 pm

I mean in the options for paste special.
LibreOffice 7.2.1 on Xubuntu 21.04 and 7.2.1 portable on Windows 10
User avatar
Hagar Delest
Moderator
 
Posts: 30168
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: Functions and formulae translator

Postby gerard24 » Sun Jun 19, 2011 9:02 pm

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
gerard24
Volunteer
 
Posts: 958
Joined: Sat Oct 30, 2010 5:12 pm
Location: France

Re: Functions and formulae translator

Postby MrProgrammer » Tue Jul 05, 2011 6:05 pm

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 140 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).
User avatar
MrProgrammer
Moderator
 
Posts: 4184
Joined: Fri Jun 04, 2010 7:57 pm
Location: Wisconsin, USA

Re: Functions and formulae translator

Postby gerard24 » Tue Jul 05, 2011 6:47 pm

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
gerard24
Volunteer
 
Posts: 958
Joined: Sat Oct 30, 2010 5:12 pm
Location: France

Re: Functions and formulae translator

Postby Villeroy » Tue Jul 05, 2011 7:06 pm

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
Villeroy
Volunteer
 
Posts: 30411
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Functions and formulae translator

Postby MrProgrammer » Fri Jul 29, 2011 6:56 pm

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).
User avatar
MrProgrammer
Moderator
 
Posts: 4184
Joined: Fri Jun 04, 2010 7:57 pm
Location: Wisconsin, USA

Re: Functions and formulae translator

Postby gerard24 » Fri Jul 29, 2011 8:46 pm

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
gerard24
Volunteer
 
Posts: 958
Joined: Sat Oct 30, 2010 5:12 pm
Location: France


Return to Calc

Who is online

Users browsing this forum: No registered users and 11 guests