Shame, as I agree that something like that would solve a lot of problems.
At the moment, excel and spreadsheet solutions as a whole are so different from any actual programming/data work that goes on, that business logic has to be completely rewritten (e.g.) a team of excel based analysts pass something over to developers to integrate into data pipelines.
Would be great if tools kept people at least in the same ballpark.
It would not need to be particularly elegant. If the program-spreadsheet exports the right data, it can be rendered or GUI-ed separately - even by a program that watches for export file changes. Even by a spreadsheet viewer for the people who insist.
A notebook lets you use various libraries or outside programs to do the rendering.
If have also done this with graphical objects (think postscript). The program is on one side and generates and composes primitives into useful blocks and arrangements. A - for example - postscript viewer is on the side, watches for updates and re-renders the thing. You now have graphics as programming, with synchronous-enough rendering.
For many years now, I have handled that by writing my own. For the right applications, you can use your favorite programming language and "simply" restrict yourself to working on named cells and cell arrays (instead of all the possible data structures that are normally available.) But - of course - that leaves you having to re-implement spreadsheet features on your own. When it's a long life program, that's still worth it.
CPAN has a few modules in these general directions... Spreadsheet::Engine, Spreadsheet::Perl, Spreadsheet::Edit - some independent, some acting on a spreadsheet file.
Shame, as I agree that something like that would solve a lot of problems.
At the moment, excel and spreadsheet solutions as a whole are so different from any actual programming/data work that goes on, that business logic has to be completely rewritten (e.g.) a team of excel based analysts pass something over to developers to integrate into data pipelines.
Would be great if tools kept people at least in the same ballpark.