Re:Scientists rename human genes to stop MS Excel from misre...
by sincerely on Thursday August 06, 2020 @12:44PM
(#24072690)
Sorry for asking but are you familiar with how MS Excel aggressively converts data to dates? There's no way to "sanitize" it (without resorting to hacky solutions like including extra characters) and even if you fix the data, it will re-change them to dates the next time you open the file.
[ Parent
| on HN ]
Re:Scientists rename human genes to stop MS Excel from misre...
by jaywalk on Thursday August 06, 2020 @12:51PM
(#24072772)
You're simply incorrect. If you set the column format to Text it will never convert data to dates, including when you open the file.
Re:Scientists rename human genes to stop MS Excel from misre...
by zozbot234 on Thursday August 06, 2020 @12:58PM
(#24072881)
Great, how do you set a custom column format in a CSV file?
Re:Scientists rename human genes to stop MS Excel from misre...
by ryukafalz on Thursday August 06, 2020 @03:18PM
(#24074451)
I'm only familiar with LibreOffice and not Excel myself, but: if you want to be sure a column is treated as text in a CSV file, you have LO quote text fields on save, and have it treat quoted fields as text on import. I assume Excel must have similar options.