• 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.

    • jaybone ( jaybone@lemmy.zip ) 
      link
      fedilink
      English
      arrow-up
      4
      ·
      8 個月前

      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?

      • Resonosity ( Resonosity@lemmy.dbzer0.com ) 
        link
        fedilink
        English
        arrow-up
        6
        ·
        8 個月前

        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.

  • Korhaka ( Korhaka@sopuli.xyz ) 
    link
    fedilink
    English
    arrow-up
    28
    ·
    8 個月前

    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.

  • LogicalDrivel ( LogicalDrivel@sopuli.xyz ) 
    link
    fedilink
    English
    arrow-up
    26
    ·
    8 個月前

    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.

  • Æ ( Ash@piefed.social ) 
    link
    fedilink
    English
    arrow-up
    11
    ·
    8 個月前

    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.

  • Dem Bosain ( DemBoSain@midwest.social ) 
    link
    fedilink
    English
    arrow-up
    9
    ·
    8 個月前

    I had a user come to me with a PDF issue my app was generating. They kept getting the document in landscape, and wanted it on portrait. They were the only user with this issue, and it stumped me. I checked the underlying code, and everything was set to portrait mode, except the last page, which contained a sketch and was set to landscape mode.

    I asked him to show me exactly what he did when he made the PDF. Instead of just downloading the provided PDF, he had his system set to open it on Adobe Reader. He would then use a PDF printer (Microsoft, or cutePDF) to save the doc. His printer was set to landscape.

    • Freakazoid!  ( Boppel@feddit.org ) 
      link
      fedilink
      arrow-up
      18
      ·
      8 個月前

      tell it to me at the first day and i will. the thing is if you work with pdf you better know how to use pdf format. your competence should be part of the reason why you earn more. if your boss works with a computer for more than a year and still struggles it’s not a sign of “i don’t need to know that”, but idgaf. these people never needed to climb a ladder hence they don’t know shit about the environment in which they work and slow everybody else down.

      • starik ( starik@lemmy.zip ) 
        link
        fedilink
        arrow-up
        2
        ·
        8 個月前

        If someone needs to save pdfs on a regular basis, they remember how to do it. If not, they don’t.

        By the way, isn’t it something weird where instead of using Save As, you have to go to Print, and then save as a pdf from there? Who the fuck cares

      • Sable saun­tered into the Burg­er Lord. It was ex­act­ly like every other Burg­er Lord in Amer­i­ca. [But not like every other Burg­er Lord across the world. Ger­man Burg­er Lords, for ex­am­ple, sold lager in­stead of root beer, while Eng­lish Burg­er Lords man­aged to take any Amer­i­can fast food virtues (the speed with which your food was de­liv­ered, for ex­am­ple) and care­ful­ly re­move them; your food ar­rived after half an hour, at room tem­per­a­ture, and it was only be­cause of the strip of warm let­tuce be­tween them that you could dis­tin­guish the burg­er from the bun. The Burg­er Lord pathfind­er sales­men had been shot twenty-five min­utes after set­ting foot in France.] McLordy the Clown danced in the Kid­die Ko­rner. The serv­ing staff had iden­ti­cal gleam­ing smiles that never reached their eyes.[…]

        Sable went up to the counter.

        “Hello-my-name-is-Marie,” said the girl be­hind the counter. “How-can-I-help-you?”

        “A dou­ble blaster thun­der big­gun, extra fries, hold the mus­tard,” he said.

        “Anything-to-drink?”

        “A spe­cial thick whip­py chocobanana shake.”

        She pressed the lit­tle pic­togram squares on her till. (Lit­er­a­cy was no longer a re­quire­ment for em­ploy­ment in these restau­rants. Smil­ing was.)

    • Korhaka ( Korhaka@sopuli.xyz ) 
      link
      fedilink
      English
      arrow-up
      2
      ·
      8 個月前

      You would be right, I can’t afford ultra processed foods. Root veg and grains for me with legumes if I am feeling fancy. Although I do have rosemary now because I pirated the plant.

  • Everyone here is bashing in op, but when you have to help the 50eth person who clearly doesn’t even understand the fundamentals of their job, with editing a word file even tho you already sent them the tutorial, it just gets to you. But I guess I did sign up for first level support.

  • swelter_spark ( swelter_spark@reddthat.com ) 
    link
    fedilink
    English
    arrow-up
    3
    ·
    8 個月前

    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.

  • titanicx ( titanicx@lemmy.zip ) 
    link
    fedilink
    arrow-up
    2
    ·
    8 個月前

    I hate techs that think like this. Shit i can’t do a doctor’s job, I can’t do an architects job. I don’t expect them to do mine. In fact I want then to pay me all to do my job because they can’t do it.

    Fuck you. Do you job better then them and be worthy of your money