News for hackers. Stuff that matters.
Re:Excel Labs, a Microsoft Garage Project by wslh on Friday May 26, 2023 @07:37AM (#36082791)
It is a grey area, spreadsheets are great but at some point you are building a mammoth with it. I also find Excel, and Google Sheets outdated on its own "form-factor".

It would be great to hear from the HN community about ways to improve spreadsheets. For example, adding new types and easier integrations with other systems. Also having views/forms. Lotus Notes was revolutionary in this aspect. Excel is the measure because they have a good engine. Probably we need to create a great DAG engine and put the spreadsheet over it.

Re:Excel Labs, a Microsoft Garage Project by bradrn on Friday May 26, 2023 @07:53AM (#36082903)
> It would be great to hear from the HN community about ways to improve spreadsheets.

I’m working on this! Very early days so far, and I have nothing much to show for it yet, but I do have some ideas on integrating static type inference and proper data structures into spreadsheets. My initial prototype is at [0]: it’s horrifically buggy in just about every way (don’t even try to get it working!), but the screenshot should give some idea of what I’m thinking should be possible.

[0] https://github.com/bradrn/nexo

Re:Excel Labs, a Microsoft Garage Project by operator-name on Friday May 26, 2023 @08:40AM (#36083276)
There's https://pyspread.gitlab.io/, which uses python. On the more programmable side you've got Jupyter with https://github.com/ipyflow/ipyflow and https://github.com/fonsp/Pluto.jl.
Re:Excel Labs, a Microsoft Garage Project by pcthrowaway on Saturday May 27, 2023 @03:38PM (#36097529)
Grist looks similar, and also interesting: https://www.getgrist.com/

The tables are sqlite tables, so the schema has to be rigid, while I think they also offer views that allow you to make more user-friendly views. They also let you run Python inside the formula

Re:Excel Labs, a Microsoft Garage Project by calvinmorrison on Friday May 26, 2023 @09:05AM (#36083543)
I thought a general purpose spreadsheet language would exist. Would be cool to see programs 'operate', visually
Re:Excel Labs, a Microsoft Garage Project by duped on Friday May 26, 2023 @11:39AM (#36085593)
> Probably we need to create a great DAG engine and put the spreadsheet over it.

Why a DAG? You might want recursion. We have pretty great computational models already, I think that what you're talking about is an interface into such a model (a statically typed language) through a spreadsheet like interface, which isn't totally revolutionary.

The problem is making something that can unseat a behemoth like Excel. The only things that seem to have made a dent are Sheets (on price) and services that unbundle Excel into no-code/low-code products where you make your money by not being as powerful.