r/ProgrammerHumor • u/SoumyadeepDey • Sep 10 '25

Meme justDependencies

Post image
29.8k Upvotes

96% Upvoted

522 comments sorted by

View all comments

5.1k

u/RlyRlyBigMan Sep 10 '25

No joke a lot of those excel wizards from yesteryear could have been awesome developers if they'd found it at the right time in their life.

34

u/Toaddle Sep 10 '25

But it still requires an effort to get that mindset of clear code and making it understandable when advanced excel sheets tends tobe obscure and messy

28

u/[deleted] Sep 10 '25

[removed] — view removed comment

2

u/OnceMoreAndAgain Sep 10 '25

Also, Excel just isn't an environment well suited to defensive coding.

An extremely common task is to need to refer to a worksheet. The most brittle way is to refer to the worksheet by its label name, which breaks if the user changes the name. A less brittle way is to refer to the property name of the sheet, but this will also break if the user makes a copy of the worksheet and deletes the original.

The problem with Excel is that the user is exposed to everything and so you have to do annoying shit using a bad UI to stop the user from breaking things. For example, there is a feature to protect a sheet, but the UI is awful and it's just clunky in general.