Spreadsheets: Functional Programming for the Masses (2014) [slides]

Re:Spreadsheets: Functional Programming for the Masses (2014... by matheusmoreira on Tuesday November 10, 2020 @09:41AM (#25046445)

Spreadsheets are awesome! They're extremely easy to use databases and make computing data really easy. I wish they were even more programmable than they already are. A map function would be nice...

  = MAP(A1:A, A + 10)

This would be so much nicer compared to a huge mess of ARRAYFORMULAs I'm using right now.

The ability to store multiple values in one cell like a dictionary would be awesome as well. With that I wouldn't have to implement lookup manually.

[ Parent | on HN ]

Re:Spreadsheets: Functional Programming for the Masses (2014... by laszlokorte on Tuesday November 10, 2020 @10:31AM (#25047039)

Take a look at [0] for a proof of concept how in the future it could be possible to define custom functions inside excel not via textual langauge but via tables inside the sheet.

[0]: https://www.youtube.com/watch?v=jH2Je6wUvPs

[ Parent | on HN ]

Re:Spreadsheets: Functional Programming for the Masses (2014... by paulfitz on Tuesday November 10, 2020 @10:51AM (#25047280)

In Grist spreadsheets you can store a dictionary in a cell (here's a random example https://support.getgrist.com/examples/2020-08-invoices/#ente...). It is sometimes handy though it gets ugly if overused I'd say. Grist just became open-source btw https://github.com/gristlabs/grist-core#grist (disclaimer, I work there)

[ Parent | on HN ]