Word is a pain in the ass. Resize a table column by 1px and the rest of the document gets absolutely fucked
Excel suffers from similarly frustrating UI issues, but my main problem with it is that it’s being used for things that it was never intended to be used for. On the extreme side, a company will shove all their HR info into one xlsx file and then someone will accidentally, somehow unrecoverably, delete it
More commonly, I’ve had to use it as a progress tracking/ticketing tool. An entire team adding rows, deleting rows, accidentally clearing formulas, highlighting random fucking cells, resizing columns etc. all at the same time. It’s just hell.
The only use case I can see for Access is when you absolutely must have a database and your company will not provide you a real database solution. I have experience with both, but haven’t touched Access in years (and hope to never do so again). To be fair, I also regularly use Excel for things that I should probably be using Word for because it is easier to get formatting right in Excel.
Probably true for most companies but I worked at one that had plenty of DB servers and developers, even developed their own database tech. Still, Excelitis as we called it was rampant.
Sadly, the lock-in is pretty extreme… as is user inertia. Office 365 has made the problem worse as well, even if you have something like OnlyOffice that does a good job of compatibility with Office, it can’t sync with OneDrive.
If you collaborate with non-technical people, they will expect you to work in Office formats, and won’t even entertain discussion of any alternative.
Where I was working Excel was used for the specification of scientific data. You get stuff like thousands of rows in several sheets themselves in multiple files that inherit from one another and everything is edited by hand…
And I maintained a tool that combined them to create binary files from this mess. Lot of fun.
It’s criminal that Microsoft has such a monopoly on word processing, they can’t even render text properly. It’s not an issue in Mac or Linux, but it is in all windows applications that aren’t using a chromium base.
Employer: Print out this .doc and bring it to work.
Me, with a Mac: alright, here you go.
Employer: why did you print it like this?
Me: that’s what you sent me.
I wish msoffice would just die a miserable death
Word is a pain in the ass. Resize a table column by 1px and the rest of the document gets absolutely fucked
Excel suffers from similarly frustrating UI issues, but my main problem with it is that it’s being used for things that it was never intended to be used for. On the extreme side, a company will shove all their HR info into one xlsx file and then someone will accidentally, somehow unrecoverably, delete it
More commonly, I’ve had to use it as a progress tracking/ticketing tool. An entire team adding rows, deleting rows, accidentally clearing formulas, highlighting random fucking cells, resizing columns etc. all at the same time. It’s just hell.
Abusing Excel as a crappy database is a very real and very widespread problem.
You use what ya got, and you don’t buy database software or hire a database guy until you know you need one
But access comes with office, so if you have excel you have at least a software that is intended to be used as a DB (efficacy aside)
Let’s be real, using Excel as a makeshift database is probably still better than actually using Access lol
The only use case I can see for Access is when you absolutely must have a database and your company will not provide you a real database solution. I have experience with both, but haven’t touched Access in years (and hope to never do so again). To be fair, I also regularly use Excel for things that I should probably be using Word for because it is easier to get formatting right in Excel.
Probably true for most companies but I worked at one that had plenty of DB servers and developers, even developed their own database tech. Still, Excelitis as we called it was rampant.
Nothings more permanent than a temporary solution.
Sadly, the lock-in is pretty extreme… as is user inertia. Office 365 has made the problem worse as well, even if you have something like OnlyOffice that does a good job of compatibility with Office, it can’t sync with OneDrive.
If you collaborate with non-technical people, they will expect you to work in Office formats, and won’t even entertain discussion of any alternative.
Where I was working Excel was used for the specification of scientific data. You get stuff like thousands of rows in several sheets themselves in multiple files that inherit from one another and everything is edited by hand… And I maintained a tool that combined them to create binary files from this mess. Lot of fun.
It’s criminal that Microsoft has such a monopoly on word processing, they can’t even render text properly. It’s not an issue in Mac or Linux, but it is in all windows applications that aren’t using a chromium base.
Employer: Print out this .doc and bring it to work. Me, with a Mac: alright, here you go. Employer: why did you print it like this? Me: that’s what you sent me.