News for hackers. Stuff that matters.
Re:The Intensional Spreadsheet by jkaptur on Monday April 20, 2020 @01:47PM (#22926363)
Very cool ideas. I'm surprised that the article didn't mention R1C1 mode [0], which seems to be a big step towards the "intensional" view of a formula.

0. https://bettersolutions.com/excel/formulas/cell-references-a....

Re:The Intensional Spreadsheet by zokier on Monday April 20, 2020 @03:03PM (#22927164)
I was thinking that the article overall felt bit out of touch with what Excel does these days, then I checked the date on the date on the linked original IEEE article and its from 1990, 30 years ago. No wonder it is bit difficult to place in modern context. "A while back" indeed.
Re:The Intensional Spreadsheet by laumars on Tuesday April 21, 2020 @03:46AM (#22932889)
R1C1 is even older still. It was first released in 1982 as the the cell addressing for Microsoft Multiplan (so we are talking pre-Excel).

Microsoft only later adopted A1 formulas to fall in line with VisCal and Lotus 1-2-3.

Re:The Intensional Spreadsheet by gklitt on Monday April 20, 2020 @02:33PM (#22926837)
I had the same thought -- it seems like many of these ideas overlap heavily with R1C1 mode, which is already how Excel internally manages formula copy-paste.

Joel Spolsky explaining how it works: https://youtu.be/0nbkaYsR94c?t=567

Re:The Intensional Spreadsheet by montebicyclelo on Tuesday April 21, 2020 @06:48AM (#22933726)
Seems the author of the article has now addressed this:

> It’s been pointed out that you can get something close to this with R1C1 notation. R[-2]C is the cell two columns to the left on the same row. This notation is not as general; for example we can write left(F+left F).

I'd argue it's more readable too.

Re:The Intensional Spreadsheet by maxerickson on Monday April 20, 2020 @09:21PM (#22930866)
Yeah. Here's the fibonacci example in a column:

    0
    1
    =R[-2]C+R[-1]C
    =R[-2]C+R[-1]C
    =R[-2]C+R[-1]C
    =R[-2]C+R[-1]C
(at least, how Libre Office Calc shows it)
Re:The Intensional Spreadsheet by juped on Monday April 20, 2020 @10:38PM (#22931272)
Yes, spreadsheets use relative references and transform them to absolute references as a display format.