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.

    • NoSpiritAnimal@lemmy.world
      link
      fedilink
      English
      arrow-up
      17
      ·
      edit-2
      1 year ago

      I have a spreadsheet that has been going for 20 years, across 2 companies, and hundreds of people.

      Thousands and thousands of lines, going back like an ice core sample. Zooming out is wild.

      “What’s this layer?”

      “Oh that’s when Terry worked here”

    • SatyrSack@lemmy.one
      link
      fedilink
      English
      arrow-up
      11
      arrow-down
      1
      ·
      1 year ago

      Nowhere here is it implied that they were using it instead of a database. They could run into this issue whether or not they were properly using Excel for what it is for.

          • lolcatnip@reddthat.com
            link
            fedilink
            English
            arrow-up
            1
            ·
            1 year ago

            Read the article. IMHO scientists were having problems because they were using it for a task it is ill suited for. The kind of program that is designed for storing large amounts of data and preventing accidental corruption of it is a database.

            • MrScottyTay@sh.itjust.works
              link
              fedilink
              English
              arrow-up
              3
              ·
              1 year ago

              I think scientists would use Excel more for finding out information with their data, not for storing it. You know like looking for trends and plotting graphs and whatnot.

              • lolcatnip@reddthat.com
                link
                fedilink
                English
                arrow-up
                1
                ·
                1 year ago

                I think they use it for both. They end up using it as a database because they’re familiar with it from doing data analysis. I’ve also heard of much more egregious examples, like a school using a giant Excel spreadsheet to track the applications of potential students. Need to track up to three references for each student? Make three of each column related to a reference! It’s a really gross way of storing denormalized data without any of the ACID properties databases guarantee.

    • prole@sh.itjust.works
      link
      fedilink
      English
      arrow-up
      9
      arrow-down
      66
      ·
      edit-2
      1 year ago

      I read this meme several times trying to figure out what is supposed to be funny about it… Then I realized it’s from Friends and based on a “joke” from that show. No wonder it wasn’t funny.

      Edit: mmm yes, your downvotes only strengthen my resolve. Friends is shit and has always been shit. So unbelievably unfunny.

  • Poach@lemmy.world
    link
    fedilink
    English
    arrow-up
    38
    ·
    edit-2
    1 year ago

    Microsoft fixed something and made their products better!? I don’t believe you.

    I wonder if this will fix any of my issues with excel molesting my data. It will either round my part numbers from a BoM making it useless or removing preceding zeros which breaks our inventory importing.

    • LastYearsPumpkin@feddit.ch
      link
      fedilink
      English
      arrow-up
      18
      ·
      1 year ago

      You could already, after the fact, and per cell.

      If you’re importing 100,000 rows in, the damage to your data is already done by the time you’re at the step where you can set the field to not convert.

    • MHLoppy@fedia.io
      link
      fedilink
      arrow-up
      5
      arrow-down
      1
      ·
      1 year ago

      It is, I’ve used that to prevent automatic removal of leading zeroes when reading the values of bytes.

      Based on the article it seems like it’s just a matter of not having to spend the time (and mental overhead) of doing that for all required columns and never slipping up on it (now just set and forget).

    • Mr_Dr_Oink@lemmy.world
      link
      fedilink
      English
      arrow-up
      1
      arrow-down
      1
      ·
      1 year ago

      So did i. Format cell(s) > data type (or something) then just seleect text, or custom or whatever.

  • Pretty Sure Not a Bot@lemmy.world
    link
    fedilink
    English
    arrow-up
    20
    ·
    1 year ago

    Omfg! The amount of time I screamed at Microsoft because I keep forgetting that excel changes the date format for some fucking reason and doesn’t tell you!

  • AutoTL;DR@lemmings.worldB
    link
    fedilink
    English
    arrow-up
    10
    ·
    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!

  • Magister@lemmy.world
    link
    fedilink
    English
    arrow-up
    8
    ·
    1 year ago

    I worked in a company where excel files were used as a database and then read through JavaScript to be processed…

  • MirthfulAlembic@lemmy.world
    link
    fedilink
    English
    arrow-up
    5
    ·
    1 year ago

    Took long enough. Now let’s see if they can give an option to turn off Lotus 1-2-3 compatibility stuff like single quotes starting a cell being hidden as markup.