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

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.