Re:Spreadsheet is a software development paradigm
by gugagore on Friday April 02, 2021 @10:32AM
(#26671709)
I didn't realize you can do string concatenation with + .
Re:Spreadsheet is a software development paradigm
by prepend on Friday April 02, 2021 @01:43PM
(#26673768)
You can’t in excel, but I was referring to if strong types the language could understand what to do with “+” for strings so could concat instead of fail.
Re:Spreadsheet is a software development paradigm
by DaiPlusPlus on Friday April 02, 2021 @04:48PM
(#26675808)
I'd prefer it to fail rather than overload the `+` operator for unrelated types. VB gets few things right, but of the things it does get right: using the `&` operator for string concatenation makes far more sense than overloading `+`.
Re:Spreadsheet is a software development paradigm
by IggleSniggle on Friday April 02, 2021 @11:31AM
(#26672250)
See also: why JavaScript is the way it is.
It’s funny though because so many people who crank on excel don’t know what types are. And don’t know what variables are. And don’t have the layers of mental abstraction that programmers who want types have and need.
So the expected protections don’t really happen. So while it’s nice to not convert “01” to “1” automatically, lots of errors will probably be caused by people trying to add “01” and “02” and getting “0102” and being super confused.