Scientists rename human genes to stop MS Excel from misreading them as dates

Re:Scientists rename human genes to stop MS Excel from misre... by mcv on Thursday August 06, 2020 @04:49PM (#24075320)

Do they change the data or only the representation? Several people here argued that LibreOffice preserved the original data, which would be a pretty fundamental difference in this context.

[ Parent | on HN ]

Re:Scientists rename human genes to stop MS Excel from misre... by erAck on Thursday August 06, 2020 @07:03PM (#24076335)

SEPT-2 is changed to date (that is how all major spreadsheet software works if an input is accepted as date), SEPT2 is kept as text as entered.

[ Parent | on HN ]

Re:Scientists rename human genes to stop MS Excel from misre... by erAck on Thursday August 06, 2020 @07:07PM (#24076363)

And actually it depends on the locale you work in whether SEPT is a valid month abbreviation or not.

[ Parent | on HN ]