Why would they call it Excel if it didn't EXCEL over the rest?? Checkmate DORK

/s

Same here, i had a business, 80 employees, 4 retail spaces. I used Open office and then Libre Office. I sold my business. many years back but still use Libre office today

I started on Lotus 1-2-3

I worked at a nonprofit that helped out homeless people. 500+ employees, terminals at dozens of locations, all using Ubuntu and LibreOffice for everything. It was fine. Uneventful, even. And they saved sooo much money because they never had to pay a dime to anyone besides the internal IT department. This open source stuff is imo better than the big corporate products for professional use because updates don’t break workflows as much.

Maybe sqlite?

/s

I'm a Very Serious professional (inhouse) accountant. I use Excel because Visual Basic allows me to access the file system and automate everything. I don't like it, but it is what it is. I sometimes make sheets that don't even open Excel. In Excel of course. It's probably not the right tool for that, but it's the hammer that I've got and which the company allows.

I know that LibreOffice also have macros, but in comparison, it's much more difficult to program because there isn't 1000 other accounts asking the same question online, so ressources are scarce.

Also the keyboard shortcut for Autosum. Can't find it in LibreOffice. At this point, it's the only formula that I use, because I have been accustomed to entering my data in a way that everything is a sum. Substraction is a sum including a negative number. Multiplication is a sum of sums. Division is the opposite of multiplication, so also a sum. I only use Sum, with the occasional Sumif, Sumifs and SumProduct.

I do use LibreOffice at home, but do wish they'd make a keyboard shortcut for Sum.

I'm a simple support who occasionally work with personal data stored in CSV and JSON. Libreoffice sucks. For example: deduplication hiden behind "create autofilters > press on any filter > filter by condition > standard filter > remove selected field > press options > no duplications". Cool, eh? And for some reason it doesn't work if at least one field selected, which is completely unintuitive. There other quirks too, like completely hidden in settings function to display more than 1 million rows, wich is disabled by default and there no notification that your document exceed this. I already forgot other issues that I faced with it, but yeah, not a fan of it. It's good untill you start actually use it.

That being said, it's free, open source and works most of the time, especially if you just need to view some data, from this side of things it have almost zero competition.