Re:How to Recalculate a Spreadsheet
by braindongle on Monday November 09, 2020 @04:54PM
(#25040427)
Yes, or (in this case?) interpreting it. I think of spreadsheets as visual functional programming environments. The humble spreadsheet has an interesting kinship with the most trendy, and, for some (me!), difficult-to-grok programming paradigm.
YES! This is exactly how I see it. I feel like I'm in this weird intersection of people who've spent A LOT of time in Excel and also significant time in programming to feel this way about spreadsheets but I don't know who else to talk to..
I tried making the same point on reddit the other day
https://www.reddit.com/r/excel/comments/jpb2ud/edit_a_spread...
Re:How to Recalculate a Spreadsheet
by jspotanski on Monday November 09, 2020 @09:10PM
(#25042204)
The soon-to-come LET function agrees :)
https://support.microsoft.com/en-us/office/let-function-3484...
Disclaimer: I work at Microsoft
That's awesome. So you basically allow implicit creation of off-spreadsheet named cells (sub-cells, in a sense, as they're only locally available). Very useful.
See also "Spreadsheets: Functional Programming for the Masses" by Simon Peyton-Jones et al.
https://www.microsoft.com/en-us/research/uploads/prod/2018/0...