News for hackers. Stuff that matters.

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

Re:Autocorrect errors in Excel still creating genomics headache by zozbot234 on Tuesday August 17, 2021 @01:11PM (#28212256)
> A reasonable alternative would be for example statically typing each column or row in the sheet.

Excel actually supports this out of the box. But it's one more option to set, and people get lazy.

[ Parent | on HN ]
Re:Autocorrect errors in Excel still creating genomics headache by dspillett on Tuesday August 17, 2021 @01:23PM (#28212420)
Also those properties are lost if you transfer the data to another format then back, or don't properly survive copy/cut/paste operations (often cutting will remove everything about a cell including options such as these).

As well as being easy to be lazy and not use the options, it is easy to accidentally undo them also.

[ Parent | on HN ]