News for hackers. Stuff that matters.
Re:Microsoft fixes the Excel feature that was wrecking scien... by chromatin on Monday October 23, 2023 @09:53AM (#37985659)
Perversely, this is almost the exact opposite of how to solve the problem.

Speaking from experience, the real problem with scientific data (genomics, in particular) is when it is exchanged in plain-text format and then loaded IN to Excel. Automatic type inference is what fails.

Data already in Excel format can be created/modified/exchanged without unintentional conversion if the column type is correctly specified as "TEXT".

Re:Microsoft fixes the Excel feature that was wrecking scien... by rbanffy on Monday October 23, 2023 @06:19PM (#37992371)
True, but how do you trust something that started as a CSV and was digested into Excel?
Re:Microsoft fixes the Excel feature that was wrecking scien... by chromatin on Tuesday October 24, 2023 @07:46AM (#37997731)
Unless you've done it yourself carefully, you can't