Calc has loads of small papercuts (tiny usability issues) which added together make it quite horrible to use. It's not polished.

Yeah same. I respect the huge amount of work it takes to make a suite like that, but... I'm lucky I've worked with Blender a lot to give me a good impression of open source software. If Libre was my first thing I experimented with in the open source world (and I think for many, many people it probably is), I would probably think "wow open source software is a joke, I guess you get what you pay for after all". It really makes a horrible impression. I wonder why LibreOffice has so many usability pains vs Blender, despite the fact that both applications have very high demand. Maybe it's just that LibreOffice seems really dull to contribute to?

What I hate about Calc is how it scrolls horizontally, it can't show half a column, it's the whole column or it doesn't scroll, which is pretty fucking annoying when you have large columns.

What I love about Calc is how it handles data imports. So much better than Excel, which usually turns it into garbage or adds things that aren't there.

I don’t know how many government workers you’ve met, but I wouldn’t have much hope of that haha

I love the idea of LibreOffice but it really needs to get collaborative features sorted via cloud storage providers or even network shares.

Please No.

With love and respect.

In my line of work we’re constantly changing shared documents, often at the same time. The desktop vanilla version can’t do this yet, so while I can use it happily for personal stuff I haven’t been able to get it to fit in with my job’s workflow yet.

I very much want to get off Office!

Why not? Collaborative editing is extremely useful. I've done it at work, with friends, and with my gf.

There's no reason the government couldn't own it's providers via NextCloud or something.

EDIT: I guess the big, mean old collaborative editing features are out to get us and take away our freedoms and steal our puppies. Collab editing must be Satan's work and there's no way any moral person should find it helpful.

There's also Impress, which feels like PowerPoint from 2010 or even earlier

They noted that it cannot be guaranteed safe. You can clone a specific version, and perform security audits on that specific version before deployment. Is it a lot of work? Yes. But it is indeed possible.

This already exists, look up "Collabora". It integrates very nicely with Nextcloud.