this post was submitted on 03 Jul 2024
1035 points (98.2% liked)
Technology
59605 readers
3435 users here now
This is a most excellent place for technology news and articles.
Our Rules
- Follow the lemmy.world rules.
- Only tech related content.
- Be excellent to each another!
- Mod approved content bots can post up to 10 articles per day.
- Threads asking for personal tech support may be deleted.
- Politics threads may be removed.
- No memes allowed as posts, OK to post as comments.
- Only approved bots from the list below, to ask if your bot can be added please contact us.
- Check for duplicates before posting, duplicates may be removed
Approved Bots
founded 1 year ago
MODERATORS
you are viewing a single comment's thread
view the rest of the comments
view the rest of the comments
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
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.