• ZoteTheMighty@lemmy.zip
    link
    fedilink
    arrow-up
    111
    arrow-down
    1
    ·
    27 days ago

    I recently had a hard time explaining to a coworker that the “Increase number of decimals” button in Excel doesn’t work if you already exported to a CSV with only a decimal of precision. It worked on their end because they had the excel file, but I had the CSV. I managed to come up with a clever and innovative solution to the problem though; I gave up and worked on something else.

    • TrackinDaKraken@lemmy.world
      link
      fedilink
      English
      arrow-up
      57
      ·
      27 days ago

      I managed to come up with a clever and innovative solution to the problem though; I gave up and worked on something else.

      There ya go.

    • panda_abyss@lemmy.ca
      link
      fedilink
      arrow-up
      15
      arrow-down
      2
      ·
      27 days ago

      Excel is pretty awful software.

      10-15 years ago it was good, but it just isn’t anymore.

      • Zorque@lemmy.world
        link
        fedilink
        English
        arrow-up
        21
        ·
        27 days ago

        Considering it is being saved in another format, I’d hardly consider this an excel problem.

        CSV has existed since before personal computers, much less Microsoft office.

    • jaybone@lemmy.zip
      link
      fedilink
      English
      arrow-up
      4
      ·
      27 days ago

      That’s actually pretty terrible. Can you load the csv and then save it again as an xls? Once it’s loaded, why does it care what the source format was?

      • FiskFisk33@startrek.website
        link
        fedilink
        arrow-up
        23
        ·
        27 days ago

        the original doc has the math, the csv only has the pre-calculated numbers

        you cant recover lost data by just resaving in another format lol

        • Zorque@lemmy.world
          link
          fedilink
          English
          arrow-up
          4
          ·
          27 days ago

          Is the problem that someone else is wrong and we want to relish in the agony of dealing with it?

      • Resonosity@lemmy.dbzer0.com
        link
        fedilink
        English
        arrow-up
        6
        ·
        edit-2
        27 days ago

        As soon as you convert from an .XLS file to a .CSV file, the data and sig figs used to display that data are saved while the math formulas used to calculate that data are erased.

        This means that when you try to go from .CSV to .XLS, Excel doesn’t know the original formula that created the data to then be able to display more decimal points. The formula is absolutely necessary to change sig figs of displayed data.

        The only other way I can think of that would allow one to change sig figs in .CSV data is if the .XLS file was converted with like the maximum number of sig figs displayed, or let’s say 10-20. Then in a .CSV, you can modify the sig figs to something less, like 0-20.

        But I want to say that if you save that .CSV file after the sig fig change, where you original converted it with 10-20 sig figs but then changed them to 0-20, the .CSV overwrites the data and you lose the sig figs that you concatenated.

        Result: adding decimal points in a .CSV isn’t possible.

  • ExcessShiv@lemmy.dbzer0.com
    link
    fedilink
    arrow-up
    45
    arrow-down
    3
    ·
    27 days ago

    I have a colleague making close to twice my salary struggling with IT…but he’s extremely skilled at his actual job.

      • FishFace@piefed.social
        link
        fedilink
        English
        arrow-up
        4
        arrow-down
        2
        ·
        27 days ago

        The fuck else is it? Did you come out your momma’s vajayjay being able to save a pdf?

        • borth@sh.itjust.works
          link
          fedilink
          arrow-up
          10
          arrow-down
          2
          ·
          27 days ago

          Lol, it’s just computer literacy. Most jobs require using the computer, saving a file required for the job is part of that job.

          • FishFace@piefed.social
            link
            fedilink
            English
            arrow-up
            4
            arrow-down
            1
            ·
            27 days ago

            Computer literacy is exactly what is taught in IT lessons, just like regular literacy is taught in school as well.

    • theparadox@lemmy.world
      link
      fedilink
      English
      arrow-up
      28
      ·
      27 days ago

      I overheard someone considerably high up in my organization struggling to understand the concept of an email BCC (Blind Carbon Copy).

      He was trying to figure out how to notify a large number of people via email without letting them know who else was receiving the email.

      Some things may fall under IT but they should really fall under the category of things every professional should understand.

    • fuckwit_mcbumcrumble@lemmy.dbzer0.com
      link
      fedilink
      arrow-up
      13
      arrow-down
      3
      ·
      27 days ago

      Yup. The key is are they paid to save pdfs? Or are they paid to do other things?

      I can save the shit out of some PDFs, but I’ve only ever made one sale in my entire life.

      • Are they paid to use the toilet to go to the bathroom or are they paid for other things? If they’re paid for other things, they should shit on the floor wherever they happen to be and let the janitors handle that since they’re the ones paid to clean things up.

    • GamingChairModel@lemmy.world
      link
      fedilink
      arrow-up
      3
      ·
      27 days ago

      I liken it to a professional basketball player with a low free throw percentage. If they’re still on the team and in the league despite missing 3 free throws a game, they must be really good at the other stuff.

  • LogicalDrivel@sopuli.xyz
    link
    fedilink
    English
    arrow-up
    36
    ·
    27 days ago

    We just got a new employee at work. She is in her 60s and 100% computer illiterate. I had to give her training on how to use a mouse and how to click on bookmarks to open our shared sheets. She somehow deleted everything on one sheet the first day, but shes getting better. She doesn’t own any computers and her phone is some no name model from 12 years ago. Im kinda impressed shes made it this far.

    • Pyr@lemmy.ca
      link
      fedilink
      arrow-up
      11
      arrow-down
      1
      ·
      27 days ago

      That’s the youngest I’ve heard of someone like that. My grandpa was like that and in his 90s and I still thought he should get a computer for at least banking and stuff.

      She must have been in her mid 40’s when the iPhone came out, that’s young enough to be interested and learn about the tech. She must have just actively ignored it or refused out of principle or something.

    • iegod@lemmy.zip
      link
      fedilink
      arrow-up
      5
      ·
      26 days ago

      She actually sounds like a treasure. Guide her well, and learn from her what you can.

  • Korhaka@sopuli.xyz
    link
    fedilink
    English
    arrow-up
    35
    arrow-down
    2
    ·
    edit-2
    27 days ago

    Followed by listening to them complain about how they are struggling with money because of how much their cars are costing them. Meanwhile I can’t even afford to learn to drive and had to walk or cycle to work in the pissing rain again.

    • sunflower@lemmy.dbzer0.com
      link
      fedilink
      arrow-up
      12
      arrow-down
      2
      ·
      27 days ago

      Listening to the personal financial issues of people much wealthier than you is just the worst. I hate how this can distance me from some of my friends even.

  • imetators@lemmy.dbzer0.com
    link
    fedilink
    arrow-up
    31
    ·
    27 days ago

    Been under a team leader long time ago. She double clicked all web page links. It was the first time I have been silent while witnessing something so outrageous.

  • MinnesotaGoddam@lemmy.world
    link
    fedilink
    arrow-up
    21
    ·
    27 days ago

    my dude, try having to do a job for someone who makes more that year than you will your entire life, and see them struggle with any simple task.

    it doesn’t matter the task. you will shit your gasket at the fact they will make more that year than you will your entire life, and you will not get a tip regardless. it will piss your nugget twice the flip fuck off.

    • PineRune@lemmy.world
      link
      fedilink
      arrow-up
      6
      arrow-down
      1
      ·
      26 days ago

      They don’t make that kind of money by being smart. They make it by screwing over everyone else for profit.

  • BanMe@lemmy.world
    link
    fedilink
    arrow-up
    18
    arrow-down
    1
    ·
    27 days ago

    Dean at my college makes 4x my salary, he thinks I personally invented “VPN” to confuse him and make his life difficult

    • varyingExpertise@feddit.org
      link
      fedilink
      English
      arrow-up
      9
      arrow-down
      2
      ·
      edit-2
      27 days ago

      It must be frustrating to think of oneself as king of the knowledge hill, only to be reminded by life all the time that, well, no. Of course they lash out. Can’t be them that is the problem.

      • Sculptor9157@sh.itjust.works
        link
        fedilink
        arrow-up
        1
        ·
        26 days ago

        Well, running with the analogy of a knowledge hill…not everyone can be at the top of the hill, and nobody can remain at the top of the hill indefinitely, and there is likely another hill that is higher.

        Try to find enjoyment at the top of your current hill, help others up, and look to the horizon for your next summit. Being angry about a job you chose, or performing it poorly, seems like you are only injuring yourself.

  • Æ@piefed.social
    link
    fedilink
    English
    arrow-up
    13
    ·
    27 days ago

    No word of a lie, I worked in a place where HR would print the company credit card statements, load the printed sheets back into the printer scanner, and email them to each employee individually from the copier.

  • Tja@programming.dev
    link
    fedilink
    arrow-up
    14
    arrow-down
    4
    ·
    27 days ago

    Stupid brain surgeons, don’t know how to save to pdf, I should make more money than them!

    • Lemminary@lemmy.world
      link
      fedilink
      arrow-up
      18
      arrow-down
      3
      ·
      27 days ago

      I don’t think I could trust a brain surgeon who can’t save to pdf in this day and age.

    • Sunsofold@lemmings.world
      link
      fedilink
      arrow-up
      6
      arrow-down
      2
      ·
      26 days ago

      If you are a surgeon but, in the year 2026, haven’t learned ‘File>Save As…’ or ‘click the little disk icon’ I doubt your competence to have learned anything else. Saving a file requires far less education and adaptability. I mean, it’s not exactly brain surgery.

        • Sunsofold@lemmings.world
          link
          fedilink
          arrow-up
          2
          ·
          26 days ago

          “The save icon. The same icon that’s used in every damned piece of software you used in the hopefully better part of two decades of education you got before they slapped a scalpel in your hand. If you can’t recognise it, you probably used chatGPT to fake your way through school and shouldn’t be a surgeon.” - patients of the world

  • mrgoosmoos@lemmy.ca
    link
    fedilink
    English
    arrow-up
    6
    arrow-down
    1
    ·
    27 days ago

    depends

    are they trying to export a PDF from Microsoft Word? because Microsoft makes that difficult nowadays

    • Jyek@sh.itjust.works
      link
      fedilink
      arrow-up
      5
      arrow-down
      1
      ·
      27 days ago

      It’s really not… There are several pretty straightforward ways to do it and they’re all pretty old standards. Save as > select PDF as the file type. Or if you have Adobe Reader/Acrobat installed, word has a button right under save as that says Save As Adobe PDF. Or you can print to PDF using the Adobe print function in the printers. Lastly windows has a built in PDF printer by default. All of these work pretty damn reliably. If you can’t save a PDF from a word doc, it’s either your computer or you.

      • mrgoosmoos@lemmy.ca
        link
        fedilink
        English
        arrow-up
        3
        ·
        26 days ago

        You’re showing your privilege lol

        When you save an office file to PDF and you are in a OneDrive environment, it doesn’t save it locally - it saves it to the cloud, and then downloads it locally. it’s fucked up

        I’m not going to fault people for having trouble when the “save this file as PDF” option doesnt result in a PDF immediately in the save directory

          • mrgoosmoos@lemmy.ca
            link
            fedilink
            English
            arrow-up
            1
            ·
            25 days ago

            if I remember next week, I’ll try to save one while offline and see what happens

            I can tell you that if I use “save as PDF” while online with onedrive not running (whether because I shut it down or because it crashed and didn’t restart itself), the pdf will not show up locally for me

      • Camille_Jamal@lemmy.ca
        link
        fedilink
        English
        arrow-up
        2
        ·
        26 days ago

        Control-s save as>pdf is how I do but I’m not professional I’m teen

        Still seeing classmates open chrome, search “google” in the search bar, click the link, just to end where they started is infuriating as fuck

  • swelter_spark@reddthat.com
    link
    fedilink
    English
    arrow-up
    3
    ·
    25 days ago

    I used to work at an office where all of our documents were kept electronically. A few of my coworkers couldn’t figure out how to open any file type except pdf, so whenever I added documents to the system, I’d convert anything else and add a pdf copy for them.

    Another group of coworkers was infuriated by this, because they believed I was spending hours every day scanning a ton of paper documents unnecessarily, because I guess they didn’t know any other way to create a pdf?

    I ended up being called into a meeting with my manager to justify why I was wasting so much time scanning documents. I explained that I wasn’t scanning anything, I was just opening files that we received in an electronic format and clicking “export to pdf”.

    He was blamed me for none of the people who complained knowing how to do this. We were all administrative staff.