Adding the possibility of using English for functions/formulas as an option to showing translated functions
Using English name of functions in all languaje versions of excel
same with keyboard shortcuts, stupid that bold in any other software is ctrl-b, but in ms its different depending on what language setting the machine has: stupid and a showstopper...
Software should make life easier, not more complex and break default routines you are used to...
Erik Alm commented
I've seen many suggestions on how to coax the existing translated names in edgewise, even add-ins. My suggestion is more radical:
1. Do a user survey to determine that no one needs, wants, uses or likes localized names
2. Rip out this functionality of the app as soon as possible
3. If more than 2% of the users feel they need this, add localized function names as an add-on people will have to download... you can probably put it on a server hooked up to the net via a 56k modem and no one will be the wiser ;)
I suggest this because now again, localization has flipped out in Excel (stuff gets sorted a$$wards)...
I know, it took a lot of hard work to do the translations and to get them into the app and they were going to make even children able to do Monte-Carlo regressions in Excel, but lo and behold... learning to make Excel do what you want is still like learning a new language.
Just with localization, you need to translate the solutions you find back to your language... And of course, there are more places where Excel can break. KISS people!
IMHO all localized function names should work as english aliases. To prevent a mess, an option could control if function names should be "normalized" to current language, like a command in the ribbon or when you save the book.
Edit: Looking to translate a formula, I found an add-in that could be useful : https://support.office.com/en-us/article/excel-functions-translator-f262d0c0-991c-485b-89b6-32cc8d326889
M. Didier Lamard commented
On solution could be to have a symbol (e.g. "_") to access the excel command derivated from the UI bypassing the localized function names. This for all speaking languages (including English). Example : _SUM() to acces the SUM() function in any language instead of SOMME() for French, SUMME for German. So to create an international version: =_SUM(_INTEGER(), ....,) .....
would be really great, it is a pain as it is today
Dear developers, please just one variation for function names. Really annoying. English version would be fine.
I totally agree: toggle between the installed language and English would solve a lot of questions and misunderstandings in formulas.
Márcio Moura commented
I like this post
Cristiano Galvão commented
Hey, Excel team. You could solve this request by 2 different ways.
1) Create a notation with a symbol before functions, as I commented below.
2) Create a toggle button to Show Functions in English, which would be available in all languages.
Cristiano Galvão commented
I agree. Everybody would be happy: developers, users from international teams and beginners. I suggest the possibility of write functions in English using some signal at the left to avoid name errors. Example: =#SUM(...) would be the same than =SOMA(...), =SUMA(...), =SOMME(...), =SUMMER(...). But by writing with a specific symbol, Excel would recognize as English for everybody.
In particular, for exchange and have a common ground to program or use functions there must be *one* way that works *everywhere*.
So, someone wants to learn two types of using excel - be my guest, but for those that want to use a common way, have always the english version - I am German - but it's a mess if you read anything - and most is in english - and then you have to play guessing games how this function may be named.
It would be a huge improvement if one could use his localized Excel but use the english functions always - I have not found any straight way (toggle one setting 'Use English Code'. )
Localizing is for GUI - but not for computation - you never get rid of those dependencies.
Have you ever seen a programming language that translates its built-in functions based on UI language? Me neither. But Excel does. Why? Just to make international collaboration harder!
Let functions in ENGLISH, even for other languages !!! (excel mac)
When working with Excel, cell formulas and functions are typed with local names.
E.g. SQRT is called KVROD in danish.
Any Excel sheet with danish cell formulas and functions will subsequently fail on calculating formulas when Excel language is not Danish, since KVROD is unknown in all other languages :-(
1. Excel should work with unique English formula and function names "behind the scenes" - so only Danish, German, Spanish, Russian, Portuguese etc. are display-names.
2. It should be optional to show either the unique English or the local display names, independent of the users/computers regional settings.
This has been an issue and a pain for extremely many years now. It is impossible to share calculations between Excel users using different languages.
Please fix this, before designing unimportant new icons.....
Hi, thank you for sharing your feedback. My name is Martin Ørsted and I work for Microsoft. I am involved in the localization of Office.
As a Dane I have run into the problem with localized functions as well. While I do not have a fix for that, we have released an Excel Add-in through the Microsoft Garage that helps with this specific problem. We released a Functions Translator, that supports all the languages we have localized Excel to. Since it is an add-in it is fairly integrated in Excel. It supports translation of all 800+ functions that we have in Excel, and you can also translate full formulas. It can translate between any language set you choose. We support Excel 2013 SP1 and Excel 2016 for Windows, Excel Online and Excel for Mac and iPad (Latest version of Excel).
If you are interested, you can read more here: https://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-mso_other-mso_2016/new-excel-add-in-lookup-localized-function-names/a9f1ca64-dd15-4998-8f8a-51606d66a452
Hope that this helps
Add an option, which would allow to display and edit function names in formulas either in localized form or in English.
This would simplify input of math formulas for those, who is used to use English names of those (like SUM, SIN etc.).
Besides it would simplify sharing of sheets with formulas between excel versions with different localizations.
In fact I would prefer to have option, which would allow to show _and_ edit formulas in either localized manner or in English. I really find, that typing functions like SIN() and SUM() e.g. in Russian is totally confusing and inappropriate.
Of course for those, who do not share my preferences there should still be an option to keep function names localized.
Allow an option to change formulae language without reinstalling the whole excel. It's really based on how the user has learn the formulas, so it should be easier to change.
Andre Polykanine commented
Technical summary: My enhancement request is to allow Excel 365 accepting English function and operator names in all localized versions of Office.
the Story: I needed to do a very simple thing: count characters in a cell. So I entered =LEN(D7). And boom! - I got an error: unknown name. WUT?, I said to myself. After ten or so minutes of thinking I guessed at last: since it is my work machine and everything here has to be in Russian, I installed a Russian version of Office 365. So when I entered =ДЛСТР(D7), everything worked as expected.
So what I propose is to allow English functions input as in all programming languages.
I recently moved from the UK to Germany and found myself still using English formulae when using Excel. Unfortunately, my employer supplies a German version of Excel and here go: I need to use German formulae again (I'm a native speaker, so not such a big problem).
Anyway, I also discoverd the following: Whenever I open Excel documents I've created with an English Excel in a GERMAN Excel version, it automatically "translates" the formulae from English to German type.
So my suggestion is: MS Excel should allow to choose whatever (available) language the user whishes to use (not limited to the version's language) and Excel could convert it live and as you type into the actually used language.
It would be fantastic to see that in future version of Excel.