Nextcloud, Ionos and other partners are developing an open-source office suite under the project name „Euro-Office“ as an alternative to the market-dominant Microsoft Office.
The two partners are not starting from scratch, but have forked the components of OnlyOffice available as open-source code and want to build on them. In the summer, the software is then intended to replace the previous office component Collabora in Nextcloud and the Ionos Nextcloud Workspace. A ‘technical preview’ is already available on GitHub.
While this is a good news, I think they should move from github, you know microslop copilot…
May I suggest Python ?
By the time you get tits deep in Excel to the point where other spreadsheets can’t hack it, you may as well be using a real programming language instead of VBA…
If you can do advanced Excel, you can do Python (and numpy will crush Excel in ways that aren’t even funny, well OK, it’s funny too).
btw, libreoffice calc supports python macros, so you don’t need to choose between the two
Is python realistic for non tech people? I have a lot of databases across sharepoint but no real tech knowledge beyond basics.
it was partly made for mathematicians who did not know how to develop software, but also for education. so I guess it’s a good starter language. but it allows doing way too much things that will be very confusing when overused
If you are running multiple databases you are already a “tech people”
Sharepoint is not a “database”
I would recommend learning SQL. It is made to be human readable, and we’ve been perfecting it since the 1960’s.
Python let you run SQL on any file, and standard DB technology with a very small number of lines of code. Recommend reading about Pandas
You won’t find any applicants for a secretary, HR, or accounting position if it requires knowledge of Python.
None of those positions are expected to know VBA script either.
No, but for these OnlyOffice is a viable alternative. @surgarsweat was referring to way advanced features, not something secretaries or HR or accounting will need. I have use OnlyOffice for 6 years now, and have yet to find an Excel need it could not fulfill.
Nah man. Advanced is a relative term. Making formulas in a spreadsheet can be advanced vs just typing stuff in there to make easy layouts.
Perhaps you underestimate people.
I’ve done IT consulting work for a company that had switched to an open source software stack and were forced to go back to MS because they literally couldn’t fill necessary positions and it was threatening to kill the business.
And this was at a time where there was a surplus of applicants for every position. They just all noped out when they were told they’d have to learn to use different software.
I’ve worked for dozens of companies as MSP and now I’m leading the in-house IT of a company with 300 employees. The picture is the same everywhere: Most office workers have simply memorized the exact steps needed for their role. Take away the tools they’re used to and their productivity drops to zero, while IT support workload goes through the roof.
Yup, seen it too, sucked, don’t think it’s the way forward though. Europe seems to agree, should be enough momentum.