I think that I wouldn't build spreadsheets today. I'd build a tool which allows me to build simple forms which store, edit, and view data, and a separate tool which lets me work on and transform that dataset through a visual programming pipeline.
This would allow me to decouple the storage format, the views, and the transformations from each other, and make for a significantly more maintainable system for most things that spreadsheets are commonly used for.
Comments
I think that I wouldn't build spreadsheets today. I'd build a tool which allows me to build simple forms which store, edit, and view data, and a separate tool which lets me work on and transform that dataset through a visual programming pipeline.
This would allow me to decouple the storage format, the views, and the transformations from each other, and make for a significantly more maintainable system for most things that spreadsheets are commonly used for.