sc

Should be COBOL

Because you don't even dare breathe on load-bearing legacy systems. You want to change the whole app, you insolent heretic?!

Just gonna drop this here: http://visidata.org/

Blows excel out of the water, at least for tabular data (which, frankly, is what all financial data should be... Cell-based formulas are a mistake).

As someone who works in a Fortune 100 company, the number of spreadsheets we have for the vast majority of our tasks...

The biggest issue I've seen is how do you get a bunch of data to look and behave between a bunch of users who have different skillsets and varying knowledge about how the data connects to other data?

You could build a web page with a database backend. But this takes hours when plopping the data into a spreadsheet is minutes.

How's LibreOffice at pivot tables nowadays?

Follow-up question, how's LibreOffice at telling my tech illiterate boss she has to go to IT to get admin rights to install LO so she can open the file I just sent her because I don't morally want to support Microsoft?

You can't swap Excel with anything else. Are you going to trust that millions of man-hours of work will translate perfectly? Going to take that risk with your company?

Even if you started your business with another spreadsheet, you still have to use Excel sheets from others.

three reasons:

1. power query
2. keyboard shortcuts
3. pioneer for new functions (e.g., xlookup, dot-colon, let, etc)

oh, and excel doesn't crash like a boeing at annoyingly frequent random intervals.

My only complaint is the blinding white cells. There's a reason why like every other major program uses dark mode.

It's the keyboard shortcuts. Might as well try to get people to learn Uzbek

Watch Microsoft ruin another good thing!

XKCD #2347

I 100% believe if some scripting language like Python was taught in schools instead of excel we would be in a MUCH better place. I have to deal with user created excel contraptions everyday at my work and they make me want to cry

A lot of good answers, but my bet is the third party plug-ins. Does librecalc have SAP Analysis, or the other plug-ins to connect excel to the accounting systems?

Huh. I don't know about the financial system but I'm guessing a good chunk of it is ran by some old mainframes.

It's like the retail industry, still massively relying on IBM i/iSeries/AS400. I worked for a consulting company that was doing a little bit of admin and support work for companies still using this system and the list is still very long. At least it still receives updates, and it's kind of fun/odd to work with if you like CLI, but it's super expensive and absolutely proprietary.

Libreoffice calc sucks sorry. Onlyoffice might be a good substitute.

You want us to use access? No one wants to use access I'll just make a hyperlink to another book on the last cell

Why not use database, actually. I am yet to see anything related to money that is not a rabbit hole of wildly different things interacting by wildly unexpected logic. Ffs, is writing esoteric formulae in a spreadsheet really easier than learning some SQL dialect with a few pretty advanced and specific features?

Two things: VBA and the autosum formula keyboard shortcut.

Anybody who knows what LibreOffice is already knows what those ugly hack Excel spreadsheets should have been in the first place.