News for hackers. Stuff that matters.
Re:Mistaken Identifiers: Gene name errors introduced inadver... by ams6110 on Sunday April 21, 2013 @11:22AM (#5585114)
I am surprised that this is a surprise. Anyone who has used Excel to open a CSV file of any complexity has surely encountered incorrect, automatic "interpretations" of values as dates or numbers.
Re:Mistaken Identifiers: Gene name errors introduced inadver... by pbhjpbhj on Sunday April 21, 2013 @12:50PM (#5585395)
Why wouldn't an import tool have an option "make automated conversions" or the ability to _simply_ turn automated conversions off with clear state feedback (eg as a checkable button like for overwrite/insert modes¹).

Surely MS research has shown that this is one of the great pain points with Excel/Word?

[¹ I haven't used MS Word for real in over a decade, it used to have a display of OVR in a bottom panel IIRC for when overwrite mode was on.]

Re:Mistaken Identifiers: Gene name errors introduced inadver... by lutusp on Sunday April 21, 2013 @12:59PM (#5585426)
> Surely MS research has shown that this is one of the great pain points with Excel/Word?

Perhaps, but Microsoft is infamous for ignoring Excel's many faults. An article linked yesterday described a litany of very serious statistical errors of long standing, without any indication of a timetable to repair the defects.

Re:Mistaken Identifiers: Gene name errors introduced inadver... by Pxtl on Sunday April 21, 2013 @12:12PM (#5585276)
Yeah, that. Excel's CSV behavior is worse-than-useless, which is a shame since CSV is generally treated as the easiest way to get data into Excel.