News for hackers. Stuff that matters.
Re:Lambda: Turn Excel formulas into custom functions by rajandatta on Sunday December 06, 2020 @12:07PM (#25324795)
This is extremely significant to simplifying spreadsheets.
Re:Lambda: Turn Excel formulas into custom functions by bombcar on Sunday December 06, 2020 @12:12PM (#25324843)
I see it making spreadsheets easier to convert into code, too. Many “business programs” begin as a spreadsheet.
Re:Lambda: Turn Excel formulas into custom functions by lambda_obrien on Sunday December 06, 2020 @12:40PM (#25325073)
We have services which run a "notebook as a service" so it's not too far fetched to think of Microsoft doing this with Excel spreadsheets. I bet it would take the business world by storm and would be a good move.
Re:Lambda: Turn Excel formulas into custom functions by robertlagrant on Sunday December 06, 2020 @05:34PM (#25327286)
Next up: Excel functions running as Azure Functions in the cloud.
Re:Lambda: Turn Excel formulas into custom functions by avandvrnot on Monday December 07, 2020 @12:05AM (#25329477)
I assumed that was what this is!
Re:Lambda: Turn Excel formulas into custom functions by tgv on Sunday December 06, 2020 @12:12PM (#25324839)
Yes, but there is no mention of debugging. In the hands of Excel cowboys, this can become another foot gun.
Re:Lambda: Turn Excel formulas into custom functions by bombcar on Sunday December 06, 2020 @12:20PM (#25324910)
A number of bugs will be solved by moving to it (a copied function is typo’d in one cell, etc) and you can test it pretty easily in a cell.

Excel is basically a REPL with cells.

Re:Lambda: Turn Excel formulas into custom functions by robertlagrant on Sunday December 06, 2020 @05:33PM (#25327283)
A REPL treated as a software system.
Re:Lambda: Turn Excel formulas into custom functions by int_19h on Sunday December 06, 2020 @09:06PM (#25328687)
Between this and LET (https://support.microsoft.com/en-us/office/let-function-3484...), Excel seems to be a full-fledged pure functional language now, with lexical scoping, first-class and high-order functions etc.