4 ms·
> Impossible to make reusable blocks. The click and drag down feature results in a kind-of code reuse. It bypasses the need to consciously name things. Is this
by ogogmad 5y ago
> Impossible to make reusable blocks.
The click and drag down feature results in a kind-of code reuse. It bypasses the need to consciously name things. Is this generalisable?
For small scale code, these concerns may be overkill.
- somat 5y agoClick and drag down is the opposite of code reuse, it is effectively a one time code generator. In fact it is one of the main reason I have largely abandoned spreadsheats, the behaviour I actually want is found in sql views. Calculate all items in column with one expression vs calculate items in column with unique expressions that were copy, pasted then transformed for each and every row. The other main reason I abandoned spreadsheets is row level integrity. too many times data that goes together in a row has drifted apart(sort on column subset is main culprit), another inherent problem solved by using a relational database. the solution to having excel at every desk is to have postgres at every desk. the code will be just as bad but the data integrity will be better.
- mint2 5y agoBypassing the need to consciously name things is one of the worst parts of excel. Imagine taking a data pipeline and renaming all columns and variables alphabetically and then asking someone to check the business logic Also it pushes people to include excessive parts of formulas into a single calculator rather than breaking them into comprehensible and testable chunks.