Excel seems to be localized and I absolutely hate it. A german version of excel expected me to write WENN instead of IF, or SUMME instead of SUM. It's dumb. Especially since if you're trying to look up code snippets or how to do something in excel, you'll find one in english and then have to find the corresponding german commands.
Google docs had a really interesting quirk that drove me insane for about 20 minutes while I figured it out. I was helping someone with some shared spreadsheet on Google Sheets and figured out that SUMIF(...) was what they needed, by doing a bit of searching. Except that it refused to work where I needed it even when I followed the docs to the letter, and when I explored it a bit more the function seemed to work but only randomly. I'd recreate exactly the same data in the same positions in one sheet where it would behave as I expected, but in another it would fail.
It turns out that according to the locale Sheets will change the separator for params, so in en-US it'll be:
=sumif(A1:A10, "Something", B1:B10)
while in cs-CZ it should be
=sumif(A1:A10; "Something"; B1:B10)
On the one hand, that's really quite cool and impressive. On the other, I would never have expected a language or development environment to support different syntax depending on the locale in use.
The Italian version of Excel requires “;” to serate clauses in the localised version of IF, SE(<condition;<if-true>;<otherwise>) and other differences beyond mere translations, and that drives me up the wall and through the roof.
