Besides the jank, you can set up libreoffice inside a docker container and server it over https. There you now have cheap-ass MS365.
Technology
This is a most excellent place for technology news and articles.
Our Rules
- Follow the lemmy.world rules.
- Only tech related news or articles.
- Be excellent to each other!
- Mod approved content bots can post up to 10 articles per day.
- Threads asking for personal tech support may be deleted.
- Politics threads may be removed.
- No memes allowed as posts, OK to post as comments.
- Only approved bots from the list below, this includes using AI responses and summaries. To ask if your bot can be added please contact a mod.
- Check for duplicates before posting, duplicates may be removed
- Accounts 7 days and younger will have their posts automatically removed.
Approved Bots
There's also a network version of LO.
Microsoft Office is adding in AI? Spreadsheets can take a lot of work to create, I can just imaging an AI tool going in the messing one little thing up, and it being near impossible to find the error. Or not even know your calculations aren't being done the way you want.
I can just imaging an AI tool going in the messing one little thing up, and it being near impossible to find the error.
It doesn't put formulas into the cells. It will write the formula for you, but you have to put it in yourself.
Also, there's versioning in Office, so your spreadsheet blowing up for whatever reason isn't a problem at all - just roll back to the previous version of the file.
I just find it better, to do a little research on formulas, and figuring it out yourself. You'll become better at spreadsheets. I'd have to try it though, it would depend on the actual implementation of it.
Excel is maybe the one place I can see AI being useful because lots of people can describe what they want a spreadsheet to do but not actually do it.
I just wouldn't trust it to do it right
Which means you have to check each and every formula and we all now how difficult it is to read and understand excel formulas we didn't write ourselves....
Exactly.
I’m not jazzed about AI in document editors and spreadsheet software because I’m dyslexic enough that I have trouble finding some big errors.
Copilot can design a table, and even fill out some data, but it won't input any formulas. It will write them for you and tell you where to put them, but you have to copy-paste them on your own.
Also, with versioning, even if it did and caused a problem, you could always just roll back to a previous version of the file. Not really an issue.
I like LibreOffice, but I prefer Onlyoffice.
Pandas killed VBA for me that was about the only reason I had to use an ms office suite
I have a job that involves working with spreadsheets. I have Librecalc at home and both Libre and MSOffice at work. I have also had a college course about using Excel specifically. Both really can do mostly the same things but because MS does everything in a specific (backwards) way, people trained on MS who are not otherwise "computer people" can't cope with needing to unlearn and relearn. So the end result is paraprofessionals are locked in.
I really enjoyed spreadsheets before becoming a programmer (I still enjoy them, I just spend less time on them) and basically self taught over the years using Google Sheets.
There are several really useful functions on sheets that simply do not exist in Excel, and there are others that work almost the same but not quite. Having to use Excel drives me insane sometimes because of how clunky it feels.
By contrast, using LibreCalc feels kinda how you'd expect an open source Google Sheets to feel? It's slightly clunkier, but it gets the job done and generally feels better to use than Excel
I've gone full circle
Loved sheets, then hated them because we should just use a DB
Now I do stuff in sheets with a tab explaining how I got the data because I can email it to someone and in 4 months it still answers their questions.
I used sheets because it was portable and flexible, but now I'd almost always just use a db instead.
My main use for excel now is "I need to send data to someone who isn't a programmer" and doing json > CSV conversions to see if my 3000 rows of data from a 3rd party have all the necessary bits.
I guess it depends, I can make a pivot table in like 30 seconds, which is faster than setting up and loading data into a notebook.
It's like this meme:
Alternative to Photoshop: Cracked Photoshop Alternative to Office: cracked office
XD
I’ve gradually been switching over. The UI is somewhat confusing in my experience- but the MSO UX+UI is consistently getting much, much worse as time passes