3 ms·
One of the greatest (in the sarcastic meaning of the word) work of localisation is Excel translating function names. So =SUM() is =SUMME() in German. Luckily op
by netsharc 10y ago
One of the greatest (in the sarcastic meaning of the word) work of localisation is Excel translating function names. So =SUM() is =SUMME() in German. Luckily opening the file works in different languages.
- Freak_NL 10y agoExcel deserves a special place in hell for its atrocious approach to localisation. If you were to give a Dutch Excel user a perfectly valid CSV file (i.e., comma-separated values), their Excel will fail to see it as tabulated data when they double-click the file and stuff everything in a single column. This is because someone at some point decided that in Dutch, tabulated data is (apparently) separated by a semi-colon instead of a comma, so (obviously) a file containing comma-separated values should have its values separated by semi-colons. So if you mail a Dutch person a CSV file that follows RFC 4180, chances are they can't open it properly because of Excel. A surprisingly large number of otherwise capable people get stuck at this point. (OpenOffice/LibreOffice is smart enough to recognise tabulated data when it sees it, and will simply present you with the import screen for tabulated data with its helpful live preview of the columns.)
- eriknstr 10y agoYes, oh my god, that's terrible :( I prefer LibreOffice but sometimes I run into Excel at a job or similar and the last time I did the computer I had to use was using Norwegian locale (I've been living in Norway since the age of four) and there was no way to switch it to English without admin privileges (which to me is a pretty huge WTF moment by its own right), and even if I had been able to I don't know if Excel has the English locale installed or not. So when I had to use Excel all the formulas were named in Norwegian. I downloaded a portable version of LibreOffice but that triggered the anti-virus :I Sometimes I would use Google Docs instead but for company confidential information I obviously won't upload that data to Google so then I'm stuck with Excel. Even for non-critical data Google Docs might not be an option simply because you are working on the file together with someone else who is using Excel and constantly uploading and downloading the file would be annoying, as well as the risk of Google Docs not supporting 100% of the features of Excel leading to complicated spreadsheets getting mangled. (Same problem with using LibreOffice to work with someone using Microsoft Office.)