Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

Excel 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.)



Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: