4 ms·
Yep, same in Excel. And as a Spanish Excel user, I can attest it's a pain. If you find a solution for a nontrivial Excel problem online, chances are it will be
by Al-Khwarizmi 7y ago
Yep, same in Excel. And as a Spanish Excel user, I can attest it's a pain. If you find a solution for a nontrivial Excel problem online, chances are it will be in English. Then, you need to manually translate function names to Spanish to make it work in Spanish Excel. Translations are often non-obvious (average is PROMEDIO, not MEDIA? really?).
While I understand localization can be useful for a subset of users, at least they could have made the English function names also work, or have a suggestion mechanism to suggest the Spanish translation if you type an English function name. I don't understand why they don't do this.
Anyway, the problems of name localization are nothing compared to the problems of using commas as decimal separator. People from English-speaking countries will never know how many extra hours of life they have from not fiddling with decimal separators, text encoding programming issues, etc.
- phkahler 7y agoI would hope Excel could convert all the built in functions by changing a language setting somewhere. The problem you describe should have been the first thing to come up when they decided to localize it.