4 ms·
I've been thinking about a project exactly to replace this sort of Excel misuse. The frontend should be about as Excel-like as possible, where you can just easi
by mcv 5y ago
I've been thinking about a project exactly to replace this sort of Excel misuse. The frontend should be about as Excel-like as possible, where you can just easily type (or import) as many rows and columns you like, but without the formulas and other real spreadsheet calculations. Instead, make it easy to add data types, validation for those types, foreign keys, etc, and store the whole thing in a database.
- criddell 5y agoSounds like MS Access.
- nicoburns 5y agoYeah, that's pretty similar to what I want. The other feature I'd love is the ability to add "Formatting rows" which are rich text and are marked as not being part of the data. They're merely decorative. I find such formatting is often considered essential for client-facing spreadsheets (somewhat understandably so they know what's going on), but it makes it quite messy to extract data from the sheet.