I hate windows. But I have to use it for work. The worse it gets, the more I want to break free completely, minimise my exposure to this OS. The only part I truly cannot do without I think is Microsoft Excel.

Replacing with Excel 2016 or only using webversion or so is insufficient for sure, for work it needs the SharePoint/auto save etc etc stuff. Also power query getting data from SharePoint online.

Replacing with Libreoffice or so seems completely impossible, there’s too many ‘special’ files in organisation, with .xlsm macro mess, I don’t control all that, I can’t fully steer away from such mess but need full functional access.

Other than Excel, I think I could do all my work from a Linux desktop.

Is it possible by now, reliably working in an up to date excel from a base system Linux? What is the way? Have people done this? How? Do I need to run a virtual machine with win11? How do I do that? Does anyone here have experience with it? I have high degree of control over work devices and boss couldn’t care less, as long as I can get my work done.

Thanks and sorry if this is the wrong community for this question (where would it belong better?)

  • JC1@lemmy.ca
    link
    fedilink
    arrow-up
    41
    ·
    2 days ago

    To use Excel with macros, I don’t even think the web version will cut it. Your only option is to use something like winboat to use excel inside a windows docker container as far as I know.

  • Ardens@lemmy.ml
    link
    fedilink
    arrow-up
    7
    arrow-down
    1
    ·
    21 hours ago

    So, you are caught by MS… Either accept it, or do what is right.

  • JanUwU42@discuss.tchncs.de
    link
    fedilink
    arrow-up
    12
    ·
    21 hours ago

    There’s a software called Winboat which integrates Windows apps natively in your Linux system and under the hood it’s spin up a virtual machine for it. You can try that for Excel

  • obnomus@lemmy.ml
    link
    fedilink
    English
    arrow-up
    8
    ·
    1 day ago

    I tried libreoffice too but you have to change a few settings so it’ll be compatible with ms office but it still isn’t perfect, btw Onlyofficr worked great for me, I hope it works for you too.

  • Broken@lemmy.ml
    link
    fedilink
    arrow-up
    15
    arrow-down
    1
    ·
    1 day ago

    There is no Excel alternative. It sucks, bit its the reality. I run a VM specifically for a couple windows apps and 90% of that is excel.

    I use version 2019 and manipulated the installer to only install excel and none of the other office suite apps.

    You can also do the same in a docker container instead of VM (winboat) if that’s more your jam.

    If you want more info on any of that I’d be glad to give you more details.

      • Broken@lemmy.ml
        link
        fedilink
        arrow-up
        3
        arrow-down
        1
        ·
        16 hours ago

        That’s my point. There are lots of spreadsheet options, but if they don’t meet all the needs then they really aren’t alternatives. Maybe it’s semantics, but I find that definition to not be misleading and keep expectations in line.

        • Knock_Knock_Lemmy_In@lemmy.world
          link
          fedilink
          arrow-up
          5
          ·
          14 hours ago

          I’m saying that case by case, person by person there are alternatives (software and/or processes). E.g.

          • If you want features A,B,C then use alternative X

          • If you want features C,D,E then use alternative Y

          • If you want features A,D,F then use alternative Z

          But if your team needs A,B,C,D,E & F then we come to your point that there is no alternative.

          I just didn’t want people reading this thread to automatically jump to the “must use excel” conclusion.

          • Broken@lemmy.ml
            link
            fedilink
            arrow-up
            2
            ·
            13 hours ago

            Gotcha. That’s a fair point. I kind of jumped to the end because the typical response is to “just use libre office” and OP is clearly a power spreadsheet person where that’s not gong to work.

  • rjek@feddit.uk
    link
    fedilink
    arrow-up
    6
    ·
    2 days ago

    Does CrossOver Office support a version of Excel which ticks your boxes? Are you in a position at your workplace to move them off Excel? I honestly have never found an organisation where they were using it for what it was meant for, often being used in place of proper tools - databases, issue management systems, requirements tracking, etc - where the better tool would be better and cheaper.

    But, like JIRA, the people who make decisions only know one tool, and that tool is a hammer.

    • freebee@sh.itjust.worksOP
      link
      fedilink
      arrow-up
      1
      ·
      2 days ago

      Bingo on the used as database ;) It’s very hard to move them away from that, I have insufficient impact on that

  • e8d79@discuss.tchncs.de
    link
    fedilink
    arrow-up
    78
    arrow-down
    2
    ·
    2 days ago

    Separate your personal and your work computer. You don’t want to be in a situation where you have to explain a software issue caused by your decision of not running standard software. Put Windows and all work related software on a separate work laptop and use remote desktop from your Linux PC to do your job.

    • grue@lemmy.world
      link
      fedilink
      arrow-up
      54
      ·
      2 days ago

      And more to the point, your work computer should be provided by your employer. If you’re buying that shit yourself, you’re a chump who’s being taken advantage of.

      • GlenRambo@jlai.lu
        link
        fedilink
        English
        arrow-up
        29
        ·
        2 days ago

        I dont think this is mentioned enough. These days it seems a given that you’ll install XYZ app on your personal phone, or use your personal PC for something.

        No. If you require me to install something then I require a device to install it on.

        I also think people dont realise that often throguh active exchange IT can fully wipe your device. And Ive seen too many shitty IT operators who would accidentally do this.

        • florge@feddit.uk
          link
          fedilink
          arrow-up
          12
          ·
          1 day ago

          There’s an episode of darknet diaries where this kid ‘hacks’ into his old school network and wipes everyone’s (including a load of parent’s) phones because they had exchange on their phones for school email.

    • kumi@feddit.online
      link
      fedilink
      English
      arrow-up
      17
      arrow-down
      1
      ·
      edit-2
      1 day ago

      Separate your personal and work computer

      nods enthusiastically
      Important for security of both the employee and the company. Don’t mix business and pleasure. It’s the only thing that makes sense!

      Put Windows and all work related software on a separate work laptop and use remote desktop from your Linux PC to do your job.

      What? No! Keep them separate! This is how people get pwned. Don’t backdoor your employers machine from your personal PC or vice versa!

      • e8d79@discuss.tchncs.de
        link
        fedilink
        arrow-up
        5
        ·
        1 day ago

        If the employer wants to prevent remote desktop sessions they can configure it that way with group policies and an always on VPN. In this case they are apparently fine with a personal computer being used which makes RDP actually a slightly more secure solution.

        • kumi@feddit.online
          link
          fedilink
          English
          arrow-up
          1
          arrow-down
          2
          ·
          edit-2
          1 day ago

          In this case they are apparently fine with a personal computer being used

          Where? Looks ambiguous. From all we know this is a work computer provided by the employer. It’s more likely to be an oversight or deprioritized/neglected.

          which makes RDP actually a slightly more secure solution

          I do not see how that folllows.

          If both the company and employee are indeed fine with the RDP, it should be no problem to get that confimed from IT in writing.

  • Luke@lemmy.ml
    link
    fedilink
    English
    arrow-up
    21
    ·
    2 days ago

    You could use something like WinBoat to make installing and using a virtual machine for Windows a lot easier. It also makes Windows apps feel almost like they are native to your Linux desktop, which is nice.

    Alternatively, you could try running Excel in wine using Bottles, but I’m not sure how well that’ll go since Excel is kind of a monster of an application.

  • SteveTech@aussie.zone
    link
    fedilink
    arrow-up
    6
    ·
    1 day ago

    I avoid O365 as much as possible, but when I need to, I do occasionally use it with Crossover and it seems to work. Activation was a little bit janky, but did work.

    Crossover is a paid version of WINE, and the other apps I’ve seen mentioned run Windows in a VM and forward the apps through RDP. There are advantages to both approaches, but I prefer the efficiency of Crossover.

    • Jess@lemmy.world
      link
      fedilink
      arrow-up
      1
      ·
      18 hours ago

      It’s been a year (maybe two) since I last tried. I tried activating mine with my work account and got caught up on the Duo 2FA not working. When you activated yours, did you have to go through any 2FA prompts? If you did, do you remember what tricks (if any) you had to use to make it activate successfully?

      • SteveTech@aussie.zone
        link
        fedilink
        arrow-up
        1
        ·
        10 hours ago

        Yeah it used to be broken for me too, I think only recently did it actually let me activate it. My university also uses Duo 2FA, and I activated it fine. But sometimes it doesn’t activate on the first try, you have to reopen office a few times.

        Also it seems to only let you activate it, you can’t actually sign in with your account for online features yet.

  • spaghettiwestern@sh.itjust.works
    link
    fedilink
    arrow-up
    4
    ·
    2 days ago

    I’ve tried various methods to run a couple Windows programs I use occasionally and most reliable method I’ve found (without buying a commercial package like Crossover) is a VM. With a decent multi-core processor and enough memory the only downside I’ve found is it makes my laptop run warm.

    • CarrotsHaveEars@lemmy.ml
      link
      fedilink
      arrow-up
      7
      ·
      1 day ago

      But the slowness… I have a stroke every time I press tab after any git command in Git Bash. The piece of shit takes three seconds to respond. In Linux it happens instantaneously.

        • xthexder@l.sw0.com
          link
          fedilink
          arrow-up
          2
          ·
          16 hours ago

          I fully blame this on NTFS being terrible with metadata and small files. I’m sure everyone’s tried copying/moving/deleting a big folder with 1000s of small files before and the transfer rate goes to nearly 0…

          • atzanteol@sh.itjust.works
            link
            fedilink
            English
            arrow-up
            1
            ·
            11 hours ago

            Well - Windows has always had poor “fork()” performance compared to Linux (Windows applications prefer threads). So running lots of small applications that do lots of forking will take a performance hit.

            • xthexder@l.sw0.com
              link
              fedilink
              arrow-up
              1
              ·
              edit-2
              9 hours ago

              I don’t think File Explorer on Windows uses fork() to copy files? If it does, that’s insane. I don’t think git calls fork per-file or anything either, does it?

      • xthexder@l.sw0.com
        link
        fedilink
        arrow-up
        1
        ·
        edit-2
        16 hours ago

        On the bright side, you’re getting paid to wait around ( /s because I know the feeling, and it’s just slow enough you can’t step away and do something else)

      • mvirts@lemmy.world
        link
        fedilink
        arrow-up
        5
        ·
        1 day ago

        I get paid by the hour! 😅 But for real though it’s a struggle. Mostly I try to use msys2 for everything but. I still have native git. There are some long standing bugs that make the vim excruciatingly slow to open or close, really I should go try to fix it but it doesn’t feel like a fun problem.

    • mrgoosmoos@lemmy.ca
      link
      fedilink
      English
      arrow-up
      2
      ·
      1 day ago

      the problem is my patience and frustration

      I want to get my shit done and move on with my day, not sit here waiting on stuff and getting RSI from navigating directories so slowly

  • nutbutter@discuss.tchncs.de
    link
    fedilink
    arrow-up
    12
    ·
    15 hours ago

    You can try Winboat.

    It uses docker or podman to create a windows container and run windows programs, that Wine or Proton can’t run. The experience may not be snappy, as there is no GPU passthrough support yet, but it sure is seamless. I once tried Photoshop and it ran great.