this post was submitted on 24 Oct 2023
212 points (95.3% liked)

Technology

59232 readers
3406 users here now

This is a most excellent place for technology news and articles.


Our Rules


  1. Follow the lemmy.world rules.
  2. Only tech related content.
  3. Be excellent to each another!
  4. Mod approved content bots can post up to 10 articles per day.
  5. Threads asking for personal tech support may be deleted.
  6. Politics threads may be removed.
  7. No memes allowed as posts, OK to post as comments.
  8. Only approved bots from the list below, to ask if your bot can be added please contact us.
  9. Check for duplicates before posting, duplicates may be removed

Approved Bots


founded 1 year ago
MODERATORS
 

Microsoft Fixes Excel Feature That Forced Scientists to Rename Human Genes::Microsoft now allows users to disable automatic date conversion, which means scientists no longer have to worry about using alternative names for genes.

you are viewing a single comment's thread
view the rest of the comments
[–] [email protected] 10 points 1 year ago

This is the best summary I could come up with:


Microsoft recently published a blog highlighting new Excel updates that allow users to disable Automatic Data Conversion.

This comes as good news for the scientists, because in recent years they had to rename quite a few human gene names—since Excel was converting them to dates.

There was no option to disable this automatic conversion, and that ended up affecting hundreds of scientific papers.

It led to scientists taking hours out to manually fix the errors and restore the data.

As the name suggests, this checkbox displays a warning message when you’re opening a .csv or .txt file with any of the optional automatic data conversions used.

Just keep in mind that one of the ‘known issues’ with the update that Microsoft flagged in its blog is that the new conversion option doesn’t work when you’re running macros.


The original article contains 299 words, the summary contains 137 words. Saved 54%. I'm a bot and I'm open source!