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?)
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.
No web version doesn’t cut it. Thanks for the tip, I’ll look into that Winboat
So, you are caught by MS… Either accept it, or do what is right.
Is dual booting an option for you?
No, I need to work in excel so much it wouldn’t make much difference
I was saying at least keep your personal and work life separate
TIL about winboat thanks to this thread
Me too!
Habe you tried winboat? Is basically a docker container with a Windows virtual Maschine inside of it.
Found ze German
No never heard of before, but everyone here is suggesting it so I will check that out. Thanks
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.
I will look into Winboat, thanks
We both typed out a winboat suggestion at the same time lol, nice on you to include links tho :)
Run windows in a vm for work.
I got it working under both Wine and Bottles for someone that needed it, but it was a real pain in the ass, and the reports on actually successfully doing so are hit or miss.
Found this solid write up on various options and results though, which sounds like it could be helpful for you while investigating: https://gist.github.com/eylenburg/38e5da371b7fedc0662198efc66be57b
LinOffice looks promising, thanks!
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.
Plenty of memory, CPU I think is still pretty good.
It’s also possible to configure Linux to automatically pause a Virtualbox VM when the window is not in focus so Windows doesn’t keep burning CPU cycles when not actually in use.
Using something like Winboat on top of a linux distro installation might be be the best option for you, since Winboat allows you to virtualize windows on a per-application basis.
(This is not Wine, it’s essentially a barebones VM, but I don’t think you need GPU acceleration for excel lol)
What I’ve heard is it’s mainly very single core CPU heavy, GPU not very relevant. Thanks I’m going to look into Winboat for sure, being suggested a lot here
If you get stuck with Winboat, as its still a very new project, you might want to have a look at winapps, which is very similar
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.
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.
Separate your personal and work computer
nods enthusiastically
Important for security of both the employee and the company. 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!
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.
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.
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.
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.
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.
Do I need to run a virtual machine with win11?
Yes this definitely works fine. QEMU with Virt-Manager works well, you can set up as many versions of Windows as you like. Other people use VirtualBox, VMWare Workstation, etc. These all work well enough to run Windows + standard apps like MS Office or whatever you need.
So on my linux PC, I have made a KVM (Kernal Virtual Machine) using QEMU and made a Windows 11 machine inside it (and I bought a digital license for it), which I have work office and email set up. I personally only need to use it occasionally. If you give it enough resources it works decently & runs all windows software; although as it doesn’t have a dedicated graphics card it won’t look as slick as native windows 11 machine and run GPU intense software well (you can get it it’s own dedicated video card and pass it through but really isn’t worth it for just using Excel). It means I can main linux but use Windows occasionally if I really have to. It means you can have a full Windows machine with work Microsoft account set up for Office, One Drive etc - depending on your employers policies of course. You can cut down the resources you allocate it if you want to be switching between the Windows machine and other software in Linux, but Windows can be laggy without enough resources as it’s so poorly optimised.
There are sites that guide on setting up a windows 11 machine in linux, but essentially you need to install KVM modules and Virtual Machine manager in linux (available on all distros). You do need to access your PCs bios to ensure the settings that allow virtual machines to access the CPU are on (slightly different name between AMD and Intel CPUs).
Then you create a machine in Virtual machine manager, give it plenty of resources (especially if the idea being when you use it if it’s the only think you’ll be doing, give it access to most of your CPU cores and the majority of your RAM), and create a decent size virtual hard drive file (I’d say minimum 128gb or more as Windows is bloaty - you can set the virtual drive file size to be flexible so it has a max size but the actual file size is only what is used by the guest system but some file systems still use the whole space unfortunately; not sure how Windows behaves). Download the Windows 11 installer ISO, and then add that file as a virtual CD drive for your guest machine, boot the guest machine, and you should get the Win 11 installer. The VM can only see the virtual hard drive file, so you can install Win 11 safely onto the drives it sees with no risk to your PC. Then reboot and you should have a new Windows install; test it - if it works, buy a digital license (if you want…) and install Office using your 365 account OR if you have old CDs then pass those through to the virtual machine and install as on any Windows PC.
For work, I just use windows. Not my machine not my problem.
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.
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.
MSYS2 is a lifesaver!
That’s more the fault of running software designed for Linux on Windows.
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…
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.
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
