What's the worst thing you've seen Excel used for?
-
Creative solution
I'm still trying to figure out what he was trying to solve, lmao
-
Ahaha, what was he even trying to do? What was the purpose of that Excel sheet?
-
The Excel wizards always impress me.
But now I want to see what happens when the equivalent of a caveman finds a magic artifact and creates some sort of precarious magic monkey paw solution, haha
-
Lmao...
The client needs it as a table. Excel does tables, so this is the best way.
Maybe they even locked the cells to prevent downloading the images (but not screenshots lol)? (I'm trying to be generous here)
-
Yeouch. How long ago was this? It feels like the standards for even junior devs have gone way up.
...but I guess even the C-students must find jobs eventually...?
-
Oh dear...
I don't even understand how that would get past even the first couple of people using it. I imagine the idea was that they'd copy/paste the value into the password field. But did nobody ever paste the password into somewhere other than a password field and realize, "Hey, I can see this password!"...even accidentally?
-
No idea - all I remember is my dad almost crying with laughter as he told me about it
-
2024 lol. Maybe senior dev is an overstatement, he was just more senior than me. He also left a database where the main table had one varchar, freetext column that users wrote multiple fields into because it was a 'simpler user experience' . Was a pain to extract all those fields with regex...
-
Thats more work than it's worth. Just black out the cells instead.
-
A works/construction department in a medium-sized town. They had an Excel spreadsheet that had a HUGE number of screens. Anyone wanting to do commercial real-estate construction had to not only fill out these forms, but keep them uptodate and submit the updates at end of each work day.
The thing was HUGE and had lots of interdependent screens, where if you picked an item from a dropdown menu, it unlocked a bunch of other complicated screens or panels, and so forth. Each screen had 30-40 items and fields on it, and there were multiple dozens of screens you had to tab through.
To run it on the jobsite, construction contractors HAD to buy a pen and touchscreen Windows 'tablet' ($$$). The whole thing had been written and maintained by one guy over the course of a few years.
EVERYONE hated it. The guy who had written it wanted to get promoted to management, but nobody else wanted to maintain it so he was stuck.
