Q ✨ 🔜 CoSinTIL Excel localises formulas, and will error if you put the wrong language in
mildly horrifying
Matt Gray@q wait if you open a eg. German XLS document in English Excel do the formulae just stop working‽
Tachibana Kanade@mattgrayyes @q I don’t have a non-English copy of Excel to hand to test with, but based on downloading an example German XLSX file, it seems that Excel uses the English names internally, localising and delocalising them for user interaction. So if I create a file with `=SUM` and give it to a German, their interface will show `=SUMME`. (This may also be related to why Excel always changes function names to be in all caps?)
Alex@rtnVFRmedia Suffolk UK@h0m54r @mattgrayyes @q when my employers first started using MS365 for some inexplicable reason (possibly due to downloading a language pack to check a Dutch document) I ended up with a desktop with English Office apps and a laptop in Dutch, so I had to use "=SUMIF" on one and =AANTAL.ALS on the other (although you generally could transfer the XLSX files between them without problems)