SirJB7
Excel Rōnin
Hi!
I think I'm done with the finishing touches to a project related to functions and formula translations between ... a lot of languages. As you well know I use a Spanish version of Excel and every time I post a formula I feel and seem obliged to traduce it to English so as to not overcharge users who asked -may times elementary things- with the additional issue to translating from a language that they might even ignore.
I used to use many links like:
http://www.piuha.fi/excel-function-name-translation/index.php?page=espanol-english.html
http://wwwhome.ewi.utwente.nl/~trieschn/excel/excel.html
among the bests I could find, but there was always a manually search, type, research, retype...
As I recognize me lazy (I'd say absolutely efficient about unnecessary repetitive and automatable tasks), I began wondering "WTF, I can't find a f... translator!" (... and I couldn't!) -F&f stands for fabulous
- and I ended thinking "Why not building one?"... And I'm done, I finished it a couple of months ago and it was firstly intended for personal use, it just did the job, but then I thought "This might be useful for some other guys, I can share it with them", so it evolved a little.
The information and files at the websites I mentioned appeared to have many faults or incompleteness or lacks: or they were only english-spanish, or they haven't all the functions, or they were as user friendly as porcupine mating, or... always there were ors.
In my search thru the very main source of all this function names (Microsoft, obviously) I found this pages:
http://office.microsoft.com/es-es/excel-help/excel-functions-by-category-HP010342656.aspx
http://office.microsoft.com/en-us/excel-help/excel-functions-by-category-HP010342656.aspx
Playing with this and with the language codes I collected an important data source. Actually there are 94 LIP or LP (language interface packs or language packs) for Office 2010, but with that page structure (replacing the language code page) I could only find 37. Which is far beyond the best site (the second) which had 16 languages, not all functions well translated and not all functions available (I think that not even those in 2007 full version).
I said I was done... well, nearly, almost, but not 100% sure. Why?
I included every language found, 37, most of them from countries with languages different from Spanish, English, French, Portuguese, Italian (which acceptably or not I use and can handle). Among them I want to point out at those called RTL (right to left) as Hebrew and Arabic that faced me with the handling of strange text strings that when edited moving the cursor from first character to last was unusual. And I don't mention when mixing strings of both normal (left to right) and RTL languages... that was and is absolutely confusing, at least for me.
So here is my wish list, if someone can help I'd appreciate it too much:
a) do you know fully operating formula translators? no matter between what languages
b) do you know additional pages as MS's ones with other link structure URL?
c) what languages do you fluently know (among those for which there are Excel versions) so as to check let's say 10 translated formulas? I'm very interested in:
- non-latin languages (cyrillics, hindi, thai, etc.)
- RTL right-to-left languages from Middle East (hebrew, arabic, etc.)
- ideographic languages from Far East (chinese, japanese, korean, etc.)
- languages that use other chars apart from comma ",", colon ":" and semicolon ";" for list separator, decimal point and digit separator
d) would you be willing to check partially or fully a 37 by 4 word list? (words: function, type, description and version, in the 37 languages yet found)
e) have you ever faced issues of mixing/concatenating characters in different languages? i.e., "???? / Hebrew" here it seems friendly, but look at column A of sheet "Languages", copy it to another workbook and try to select characters from left to right or from right to left...
I wish to thank specially to Faseeh (at this Chandoo's website forums) for his assistance in testing and interchanging opinions about non-occidental languages.
As well as I'll appreciate any comment, suggestion, correction or idea that you might provide, I wish to thank you in advance just for reading this, whether or not you may be able to do anything about it. Please feel absolutely free to be critical, skeptical or cold-blooded cruel with your feedback.
Download link: (updated 2017)
https://www.dropbox.com/s/pc4i5v6qw...ilingual Formula Translator V1.0.19.xlsm?dl=0
Regards!
I think I'm done with the finishing touches to a project related to functions and formula translations between ... a lot of languages. As you well know I use a Spanish version of Excel and every time I post a formula I feel and seem obliged to traduce it to English so as to not overcharge users who asked -may times elementary things- with the additional issue to translating from a language that they might even ignore.
I used to use many links like:
http://www.piuha.fi/excel-function-name-translation/index.php?page=espanol-english.html
http://wwwhome.ewi.utwente.nl/~trieschn/excel/excel.html
among the bests I could find, but there was always a manually search, type, research, retype...
As I recognize me lazy (I'd say absolutely efficient about unnecessary repetitive and automatable tasks), I began wondering "WTF, I can't find a f... translator!" (... and I couldn't!) -F&f stands for fabulous
- and I ended thinking "Why not building one?"... And I'm done, I finished it a couple of months ago and it was firstly intended for personal use, it just did the job, but then I thought "This might be useful for some other guys, I can share it with them", so it evolved a little.The information and files at the websites I mentioned appeared to have many faults or incompleteness or lacks: or they were only english-spanish, or they haven't all the functions, or they were as user friendly as porcupine mating, or... always there were ors.
In my search thru the very main source of all this function names (Microsoft, obviously) I found this pages:
http://office.microsoft.com/es-es/excel-help/excel-functions-by-category-HP010342656.aspx
http://office.microsoft.com/en-us/excel-help/excel-functions-by-category-HP010342656.aspx
Playing with this and with the language codes I collected an important data source. Actually there are 94 LIP or LP (language interface packs or language packs) for Office 2010, but with that page structure (replacing the language code page) I could only find 37. Which is far beyond the best site (the second) which had 16 languages, not all functions well translated and not all functions available (I think that not even those in 2007 full version).
I said I was done... well, nearly, almost, but not 100% sure. Why?
I included every language found, 37, most of them from countries with languages different from Spanish, English, French, Portuguese, Italian (which acceptably or not I use and can handle). Among them I want to point out at those called RTL (right to left) as Hebrew and Arabic that faced me with the handling of strange text strings that when edited moving the cursor from first character to last was unusual. And I don't mention when mixing strings of both normal (left to right) and RTL languages... that was and is absolutely confusing, at least for me.
So here is my wish list, if someone can help I'd appreciate it too much:
a) do you know fully operating formula translators? no matter between what languages
b) do you know additional pages as MS's ones with other link structure URL?
c) what languages do you fluently know (among those for which there are Excel versions) so as to check let's say 10 translated formulas? I'm very interested in:
- non-latin languages (cyrillics, hindi, thai, etc.)
- RTL right-to-left languages from Middle East (hebrew, arabic, etc.)
- ideographic languages from Far East (chinese, japanese, korean, etc.)
- languages that use other chars apart from comma ",", colon ":" and semicolon ";" for list separator, decimal point and digit separator
d) would you be willing to check partially or fully a 37 by 4 word list? (words: function, type, description and version, in the 37 languages yet found)
e) have you ever faced issues of mixing/concatenating characters in different languages? i.e., "???? / Hebrew" here it seems friendly, but look at column A of sheet "Languages", copy it to another workbook and try to select characters from left to right or from right to left...
I wish to thank specially to Faseeh (at this Chandoo's website forums) for his assistance in testing and interchanging opinions about non-occidental languages.
As well as I'll appreciate any comment, suggestion, correction or idea that you might provide, I wish to thank you in advance just for reading this, whether or not you may be able to do anything about it. Please feel absolutely free to be critical, skeptical or cold-blooded cruel with your feedback.
Download link: (updated 2017)
https://www.dropbox.com/s/pc4i5v6qw...ilingual Formula Translator V1.0.19.xlsm?dl=0
Regards!
Last edited:
