News for hackers. Stuff that matters.
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.
Re:How to Recalculate a Spreadsheet by airstrike on Monday November 09, 2020 @07:54PM (#25041786)
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

Re:How to Recalculate a Spreadsheet by FabHK on Tuesday November 10, 2020 @04:55AM (#25044253)
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.
Re:How to Recalculate a Spreadsheet by Tomte on Tuesday November 10, 2020 @03:11AM (#25043748)
See also "Spreadsheets: Functional Programming for the Masses" by Simon Peyton-Jones et al.