This commit merges in a preliminary version of the spreadsheet. It shares many of the limitations of the v1.x spreadsheet:
Formulas are limited to references in the same row.
Formulas are limited to the type schemas of the current column.
The UI for inserting rows/columns/etc... is not there yet.
Nevertheless, the internals have been thoroughly overhauled:
Spreadsheets operate over a websocket. This means that computations all happen interactively on the server.
Updates are processed live, and reactively. Updates to upstream dependencies trigger re-evaluation of dependent cells.
Updates are no longer stored as a list of instructions, but rather as a set of source data re-mappings and an overlay of formulas. This representation makes the system far more amenable to the type of free-form spreadsheet that we want to (eventually) support.
In other words, this PR leaves us in mostly the same place from the user's perspective (modulo the reactive computation) as 1.x However, it also puts us in a much better place to start building more advanced system.
This commit merges in a preliminary version of the spreadsheet. It shares many of the limitations of the v1.x spreadsheet:
Nevertheless, the internals have been thoroughly overhauled:
In other words, this PR leaves us in mostly the same place from the user's perspective (modulo the reactive computation) as 1.x However, it also puts us in a much better place to start building more advanced system.