3 ms·
> Automatically converting SEPT1 to a date caused far more damage than the benefit of the fleeting convenience. Who are you to judge? For the novice, even for
by FabHK 6y ago
> Automatically converting SEPT1 to a date caused far more damage than the benefit of the fleeting convenience.
Who are you to judge? For the novice, even for most users it'll be what they want. And for the expert (or even intermediate user) it is trivial to override.
- glofish 6y agoHow exactly would you trivially correct the massive number of published results in genomics data where SEPT1 was converted to a date? 20% of publications had errors introduced by Excel in them! The real number is probably much higher (Nature had a rate of 35%). What is the rationale in saying that the benefits must still be worth it? See: Gene name errors are widespread in the scientific literature https://genomebiology.biomedcentral.com/articles/10.1186/s13059-016-1044-7 https://genomebiology.biomedcentral.com/articles/10.1186/s13... The root of the problem is not about how Excel displays information, or how Excel parses the data but that the data it tacitly changed upon saving it. Open a CSV file that has SEPT1, don't take any action, save it right away. Boom, the data has been changed and you cannot recover the original information.