Spreadsheet is a software development paradigm

Re:Spreadsheet is a software development paradigm by LogicUpgrade on Friday April 02, 2021 @08:04AM (#26670730)

There are calculated columns in SQL, which means there's no formula/value separation there either.

Therefore also spreadsheets do offer "views": all the cells are formulas.

Regarding "shit typed", so is SQLite, but it works well.

[ Parent | on HN ]

Re:Spreadsheet is a software development paradigm by PaulHoule on Friday April 02, 2021 @10:14AM (#26671586)

SQL dbs vary.

You can write

  select a from b where 1

in MySQL and Oracle, because those db's treat true and false as 1 and 0, you can write

  select sum(a=1), sum(a=2) from b

others like microsoft sql and postgresql enforce a separate boolean type which means you have to put the ternary operator into the sum.

[ Parent | on HN ]

Re:Spreadsheet is a software development paradigm by wruza on Friday April 02, 2021 @09:37PM (#26677708)

By shit typed I meant entering or pasting 1.200 into a numeric field and getting -600,000 something. This is exclusive to excel, which is “smart” enough to detect patterns in input, but not smart enough to introduce/look at the cell affinity, at locale settings or at common sense.

[ Parent | on HN ]