News for hackers. Stuff that matters.

A comment on Autocorrect errors in Excel still creating genomics headache.

Re:Autocorrect errors in Excel still creating genomics headache by Tagbert on Wednesday August 18, 2021 @03:40PM (#28226126)
If an excel spreadsheet is setup properly, this conversion doesn't happen. If the cells are designated as "text", then conversion doesn't happen.

This is definitely a problem if you are just opening a raw CSV file and editing it as the default cell type does allow autoconversion.

[ Parent | on HN ]
Re:Autocorrect errors in Excel still creating genomics headache by djbebs on Thursday August 19, 2021 @05:00AM (#28231752)
Except from personal experience I can tell you that even when you go out of your way to set the correct data types, if you try to copy paste any data into those cells excel will ignore everything you set and try to automatically change the data types.

If you know how to get it to never do that sort of thing, please let me know, because this is causing major issues in production software...

[ Parent | on HN ]