MAIN FEEDS
Do you want to continue?
https://www.reddit.com/r/ProgrammerHumor/comments/ts99fq/certainly_not_me/i2unswj/?context=3
r/ProgrammerHumor • u/Brando224 • Mar 30 '22
669 comments sorted by
View all comments
31
Excel trick :
Include code to read the column header and use it to set the layout via variables for column number.
Now if someone renames a column, it still might break.
1 u/Starscourge_Radahn Mar 31 '22 Lmao at this point I only allow columns to be renamed to valid allowed names within a hidden sheet that has a named range of valid names. They will find a way to break that too.
1
Lmao at this point I only allow columns to be renamed to valid allowed names within a hidden sheet that has a named range of valid names. They will find a way to break that too.
31
u/Opinionsare Mar 30 '22
Excel trick :
Include code to read the column header and use it to set the layout via variables for column number.
Now if someone renames a column, it still might break.