I see that Microsoft’s Excel spreadsheet program has just turned 40, which is proof that you can fool a bunch of the people all the time (provided that you bundle your foul, inadequate software into a compendium suite which just “happens” to work okay with the core operating system which, lest we forget, you also created).
I don’t know a lot about a lot of stuff, and even less about software, except that I’ve been a spreadsheet user — at times, a very heavy spreadsheet user — all the way from early 1980s VisiCalc, to SuperCalc, Lotus 1-2-3 through Quattro Pro, while having all that time avoided Excel because its first iteration was dreadful.
Then I joined a company which only used MS Excel, and insisted that I do too (as well as the stupid Word and even-worse Access. Of course, it required re-learning all my old commands in a new language — not too difficult — but what was difficult was discovering that Excel had not really improved much over the years.
So I quit using the thing, did all my development and report design work in Quattro Pro — which was still the best spreadsheet program extant — and then translated everything into Excel, which was time-consuming and also counter-productive because a great many commands I’d used in Quattro as a matter of course had no equivalent in Excel. (Bear in mind that this was back in the 1990s and early 2000s, and things may have changed since then.)
Also, Quattro’s companion database product Paradox was streets better than pretty much all other such programs back then, which hamstrung me even more.
It always struck me that MS products, like Apple’s, are great if you’ve never used anything like that before. If you have, however, and are familiar with the competitive products, MS always comes up short.
Nowadays, my needs are a great deal more modest than back then, so I use Apache’s Open Office suite (Writer and Calc) because a) they work just fine for me and b) they’re free.
Now, if I have to send someone something I wrote or crafted on a spreadsheet, I just tell the recipient to download Open Office to be able to read the stuff. (I should point out that the Son&Heir used OO Writer exclusively to write his papers all the way through college, and never had a problem — to this day it’s the only thing he writes with — but at his job at Global MegaBank Inc. he has to use Excel, which he hates more than I do.)
So Happy Birthday, Inferior Spreadsheet Product, for what that’s worth. (Nothing, by comparison to Open Office’s Calc.)
Thing is, with how M$ has set up their “M365 subscription licensing” anymore, it includes stuff that most companies consider “good enough” all included in the price of the sub. I’m an IT guy, and I’m constantly fielding requests from users to use 3rd party improved programs instead of the base M$ ones, but for the most part I have to deny them and just say “The M$ product already does that and we already have it, so… no, we won’t buy a license for something different that’s better.”
It sucks for everyone, but… there it is.
Open Office hasn’t been updated in many a year now. It’s been superceded by a product called LibreOffice which is based on Open Office, but has been very pleasantly upgraded to eliminate most of the frustrations of “dad-gummit, that’s a simple function in Excel, how the hell can I do it in Open Office Calc?” It also exports and imports modern Excel formats if you need to play nice with others.
Those of us who appreciate/need the features of Excel, but wanted to get the hell out of it because Microsoft, now have a product that has 99+% of the features, but ain’t Microsoft. (Open Office was about 60% of the features and a source of continuous frustration when trying to do serious work.)
Kim, I heartily recommend that you move to LibreOffice, if for no other reason than it is actually supported by development team and bugs get fixed.
Duly noted, and thankee. As much as I hate change, I’ll look into it.
Back in the early 90’s I was working for a camera store chain in Chicago. After getting kicked upstairs from a pro store to the purchasing department I got the job of updating the stores’s price sheets (the stores still used written receipts, no computers). We used Excel to make the price sheets. One day I had the damndest time trying to make something work. Not being the best at math I checked my algebra three times, but the formula just would not work in Excel. I asked a buddy who’d been there a year before I came up, and he told me, ya, that won’t work. And he showed me a longer formula that you had to plug in to get the right numbers. It made no sense, but that was Excel.
I haven’t made the leap to Linux yet, but to this day I’ll use ANY programs other than Microsoft’s – especially if it’s freeware. So I’ll second Uncle Kenny’s endorsement of LibreOffice.