Yeah I agree there are weird inconsistencies between formulas in Excel, Libre office and Google Sheets. In Excel Concat and concatenate are the same while in google sheets Concat only works for two strings and concatenante is more than two. In Excel other sheet cells are references like Sheet2!A1 but in Libre Office it’s Sheet2.A1 like why??
My understanding of the excel situation is management had one obnoxious engineer who said “why can’t it do X? Let’s make it do X!” And rather than plan out or coordinate the development of that function, they said “fuck Gavin is annoying. Let him run with this to shut him up.”
Years later, Gavin is no longer on the excel team, no one understands how his code works. No one is going to touch it. So it’s now a weird little thing that tethers people to excel. Not some fancy new thing. No, just a function Gavin put in 12 years ago nobody wants to deal with, because Gavin’s code is as obnoxious as Gavin himself.
Yeah I agree there are weird inconsistencies between formulas in Excel, Libre office and Google Sheets. In Excel Concat and concatenate are the same while in google sheets Concat only works for two strings and concatenante is more than two. In Excel other sheet cells are references like Sheet2!A1 but in Libre Office it’s Sheet2.A1 like why??
My understanding of the excel situation is management had one obnoxious engineer who said “why can’t it do X? Let’s make it do X!” And rather than plan out or coordinate the development of that function, they said “fuck Gavin is annoying. Let him run with this to shut him up.”
Years later, Gavin is no longer on the excel team, no one understands how his code works. No one is going to touch it. So it’s now a weird little thing that tethers people to excel. Not some fancy new thing. No, just a function Gavin put in 12 years ago nobody wants to deal with, because Gavin’s code is as obnoxious as Gavin himself.
This is my theory.