Reply to post: Re: User Error

Geneticists throw hands in the air, change gene naming rules to finally stop Microsoft Excel eating their data

Anonymous Coward
Anonymous Coward

Re: User Error

No, it very much is the tool.

Consider the following scenario: web site offers data in CSV format for download. Researcher clicks "download" link - the browser downloads the file and helpfully opens it ... in Excel - at this point the data is now mangled. The researcher clicks "save as" to save it somewhere for import into something else later.

If you don't consider that the software is the problem in the above scenario, then I would suggest you go and listen to J Nielsen and D Norman for a bit - unexpected behaviour is a defect in the software when a sufficient proportion of people find it unexpected.

Honestly, Excel's auto-formatting of dates is a menace - CSV is a perfectly fine data format for data exchange, but Excel's behaviour does make it problematic

POST COMMENT House rules

Not a member of The Register? Create a new account here.

  • Enter your comment

  • Add an icon

Anonymous cowards cannot choose their icon

SUBSCRIBE TO OUR WEEKLY TECH NEWSLETTER

Biting the hand that feeds IT © 1998–2020